Still I need to know how

[ak]

Please help me to know how can I find out that northwind invoice creation.
Specifically how that line number is coming in the invoice. Why that is not
main
form and sub form. If it is not main form and sub form how come change its
invoice number for each invoice. How to arrange this? I need a very clear
and detailed explanation from you please. I am struggling for this for long
time.
Nobody is educating me proper way.

 

[Evi]

If you look back you will see that Alan and I and others have done our best
to answer your questions and each string of messages has ended with you NOT
replying to say which bits of our messages you don't understand.
I will quote the reply I gave earlier to this same question. Please be kind
enough to read it and then tell me which bit of my reply you don't
understand.
How to create Line Numbers:

Put a text box in the section where you want the line numbers to go.
Type
=1
next to Control Source in the Properties box
In the Properties box, choose Over Group next to Running Sum.
Does this give you the results you want?


It is not reasonable to expect anyone to spend the time to write a long,
detailed explanation in a newsgroup when you haven't asked a specific
question. There are many Internet Sites (and even books which you can buy)
which give details of Access for beginners. You only need to use Google to
find them.
But the newsgroups are there to answer specific questions.
For instance, if you didn't understand how to use the sorting and grouping
box, or what the Properties box is, it would not be reasonable to expect
anyone to spend the time writing a detailed explanation because you can't be
bothered to ask the question.
However, few of us will begrudge giving you this explanation if you just say
that you don't understand that.
I do understand that it must be very difficult to ask questions in a
non-native language but please persevere.
Read our replies. Quote the bit you don't understand and we will do our best
to clarify it.
Evi

 

[ak]

I need line number in detail section. I cant see control source there. In
details section I have a field called "LINE_NO" . In this field I right
clicked to go to properties. I could not see control source there. Where
can I go ?

 

[Evi]

I see the problem. The word Control means (partly) anything that you put in
a report or a form in Design view - lines, fields, text boxes, labels, check
boxes etc.
Am I right? You have put in a text box called Line_No?
*This should not be a field in your Query*, just a text box which you drew
there.
When you first put the text box in your report, it will have the word
(Unbound) written in it.
Type
=1
in it.
(this is the same as typing =1 in the Control Source)
When the Properties box is open, click on the tab that says Data.
One of the lines there will be labelled Control Source.
It should have =1 typed next to it.
Just below that in the Properties box is a line labelled
Running Sum

Click in that and you will see a down-arrow. Here you can choose Over Group.

There is an example of one of these Running Sum controls in the Detail
section of the Sales By Year report in North Wind

Now, as for the Northwind Invoice report, this doesn't have line numbers in
it. The field that looks like Line Numbers is a field in the table called
Product ID. You will see that if (on a copy of Northwind) you delete one of
the products, there will now be a gap in the Line numbers - they won't be
consecutive (1, 2, 3, 4 etc) but may say something like 2, 4, 7 etc.



Please ask if any of this is unclear.

Evi.

 

[ak]

I have done as you told me. Let me tell you how my report can see now.
I dont want three invoices's description as below.

INV_NO : 1 Date:10/2/2008
TO : ABC COMPANY
_______________________
S# DESCRIPTION
--------------------------------

1 CUTTER 10.00
2 PENCIL 5.00
3 PEN 2.00


1 PAPER CLIP 4.00
2 RUBBER 3.00
3 STAPLER 8.00
4 PIN 6.00


1 PENCIL 2.00

 

[Evi]

That's great, it looks like you have successfully added a Counter control
Do you mean that you only want to see 1 invoice at a time or that you want
to see each invoice on a different page?
If you just mean that you don't want to see the word Description then click
on that control in the report's Design view and delete it.
Evi

 

[ak]

Dear Evi,
I want to see 1 invoice at a time. I dont want to see each invoie on a
different page as I have now. There is no issue about word "DESCRIPTION". I
know those
kind of tricks. Please comment.

 

[Evi]

OK ak. Some of the things I am telling you, you will already know.
But just in case you have missed something out.....
You need to have 1 field which is always different each record. With
invoices this is usually the invoice number.

From the look of your results, you have already used the Sorting/Grouping
box to group by Invoice Number and you have your Invoice Number and the date
in the Group Header

If this is true then check if you also have a Group Footer It may be called
Inv_No Footer if your field is called Inv_No
If not:
Click on the Sorting/Grouping box on the toolbar.
Choose your Invoice Number field in the list.
Where it says Group Footer, choose Yes.

Close the Sorting/Grouping box
Click on the grey bar which has the name of your footer (perhaps Inv_No
Footer)
Click Properties
Click on the Format tab
Next to where it says Force New Page, choose After Section.
Does this do what you want?
Evi

 

[ak]

I could follow your explanation successfully. Now line number
is ok. I need some more favor.

INVOICE NO:
I need invoice number in 2nd page
of invoice. For invoice no.1 in case there is 3 pages need in all pages
I need the no.1 in page 1, 2 and 3.
For invoice no.2 in case there is 2 pages I need invoice no.2 in page
1 and page 2.

PAGE NO:
My report has page numbers in footer. But I am not getting page number per
INVOICE as group. In case Invoice no.1 has 2 pages and Invoice 2 has 3
pages I get page numbers as below:
Invoice No.1 : Page 1 and 2
Invoice No.2 : Page 3 and 5 etc....

Please comment.

 

[Evi]

To put your invoice number on your other pages, as well as in the invoice
header, put a text box into the group footer and type
=Inv_No
Evi

 

[ak]

Dear Evi,
I could not get you. I explained in previous posting about page number
very clearly.
How to create group footer? Also I need page number not in all. Need page
number per invoice only. Invoice No.1 there are two pages. Invoice No.2
there are 4 pages. How can I make invoice Number display this way. Now
displays without grouping. Please explain as you explained clearly in
previous details. Thanks in advance Evi.

 

[Evi]

Hi Ak
To create a Group Footer:
In the Sorting/Grouping Box, click next to Inv_No
Towards the bottom of the box you will see a grid.
One of the lines says Group Footer
Choose Yes next to this.

To make your page number start from 1 again:
I've had variable success with this so give it a try, ak and let me know
what happens. If it works, at least it is simple to do!

Click on your Inv_No Header (the grey bar in Design View)
In Properties on the Events Tab click next to OnFormat and choose
Event Procedure.
Click just right of that to open a Code page
Just above the line that says End Sub, type
Page = 1

In your page footer, put a text box. Type in it
=[Page]

Note that this method does not work if you set
Repeat Section to Yes in Properties for your Invoice Number header. If that
is what you have done, then you need to put your Invoice Header details into
your Page Header.
Let me know if it works on your report.

Evi

 

[ak]

Dear Evi,
Still I did not know how can I do the following things:
As I told you, I have invoice No.1, 2 and 3.
Each Invoice has multiple pages.
For Invoice No.1 I have 3 pages.
For these 3 pages I need to display Invoice No.1
in each pages.
In Invoice No.2 I have 4 pages.
I need to display Invoice No.2 in each pages too.

Hi Ak
To create a Group Footer:
In the Sorting/Grouping Box, click next to Inv_No
Towards the bottom of the box you will see a grid.
One of the lines says Group Footer
Choose Yes next to this.

To make your page number start from 1 again:
I've had variable success with this so give it a try, ak and let me know
what happens. If it works, at least it is simple to do!

Click on your Inv_No Header (the grey bar in Design View)
In Properties on the Events Tab click next to OnFormat and choose
Event Procedure.
Click just right of that to open a Code page
Just above the line that says End Sub, type
Page = 1

In your page footer, put a text box. Type in it
=[Page]

Note that this method does not work if you set
Repeat Section to Yes in Properties for your Invoice Number header. If that
is what you have done, then you need to put your Invoice Header details into
your Page Header.
Let me know if it works on your report.

Evi

Dear Evi,
I could not get you. I explained in previous posting about page number
very clearly.
How to create group footer? Also I need page number not in all. Need page
number per invoice only. Invoice No.1 there are two pages. Invoice No.2
there are 4 pages. How can I make invoice Number display this way. Now
displays without grouping. Please explain as you explained clearly in
previous details. Thanks in advance Evi.

 

[Evi]

Hi Ak
Have you tried putting the Invoice Number in the Page Header?
Evi

Dear Evi,
Still I did not know how can I do the following things:
As I told you, I have invoice No.1, 2 and 3.
Each Invoice has multiple pages.
For Invoice No.1 I have 3 pages.
For these 3 pages I need to display Invoice No.1
in each pages.
In Invoice No.2 I have 4 pages.
I need to display Invoice No.2 in each pages too.

Hi Ak
To create a Group Footer:
In the Sorting/Grouping Box, click next to Inv_No
Towards the bottom of the box you will see a grid.
One of the lines says Group Footer
Choose Yes next to this.

To make your page number start from 1 again:
I've had variable success with this so give it a try, ak and let me know
what happens. If it works, at least it is simple to do!

Click on your Inv_No Header (the grey bar in Design View)
In Properties on the Events Tab click next to OnFormat and choose
Event Procedure.
Click just right of that to open a Code page
Just above the line that says End Sub, type
Page = 1

In your page footer, put a text box. Type in it
=[Page]

Note that this method does not work if you set
Repeat Section to Yes in Properties for your Invoice Number header. If that
is what you have done, then you need to put your Invoice Header details into
your Page Header.
Let me know if it works on your report.

Evi

Dear Evi,
I could not get you. I explained in previous posting about page number
very clearly.
How to create group footer? Also I need page number not in all. Need page
number per invoice only. Invoice No.1 there are two pages. Invoice No.2
there are 4 pages. How can I make invoice Number display this way. Now
displays without grouping. Please explain as you explained clearly in
previous details. Thanks in advance Evi.

:

To put your invoice number on your other pages, as well as in the invoice
header, put a text box into the group footer and type
=Inv_No
Evi

I could follow your explanation successfully. Now line number
is ok. I need some more favor.

INVOICE NO:
I need invoice number in 2nd page
of invoice. For invoice no.1 in case there is 3 pages need in

all
pages

I need the no.1 in page 1, 2 and 3.
For invoice no.2 in case there is 2 pages I need invoice no.2 in page
1 and page 2.

PAGE NO:
My report has page numbers in footer. But I am not getting page number
per
INVOICE as group. In case Invoice no.1 has 2 pages and Invoice 2

has
3

pages I get page numbers as below:
Invoice No.1 : Page 1 and 2
Invoice No.2 : Page 3 and 5 etc....

Please comment.



:

OK ak. Some of the things I am telling you, you will already know.
But just in case you have missed something out.....
You need to have 1 field which is always different each record. With
invoices this is usually the invoice number.

From the look of your results, you have already used the
Sorting/Grouping
box to group by Invoice Number and you have your Invoice Number

and
the

date
in the Group Header

If this is true then check if you also have a Group Footer It may be
called
Inv_No Footer if your field is called Inv_No
If not:
Click on the Sorting/Grouping box on the toolbar.
Choose your Invoice Number field in the list.
Where it says Group Footer, choose Yes.

Close the Sorting/Grouping box
Click on the grey bar which has the name of your footer (perhaps Inv_No
Footer)
Click Properties
Click on the Format tab
Next to where it says Force New Page, choose After Section.
Does this do what you want?
Evi



Dear Evi,
I want to see 1 invoice at a time. I dont want to see each

invoie
on

a
different page as I have now. There is no issue about word
"DESCRIPTION".
I
know those
kind of tricks. Please comment.

:

That's great, it looks like you have successfully added a Counter
control
Do you mean that you only want to see 1 invoice at a time or that
you
want
to see each invoice on a different page?
If you just mean that you don't want to see the word Description
then
click
on that control in the report's Design view and delete it.
Evi

I have done as you told me. Let me tell you how my report

can
see

now.
I dont want three invoices's description as below.

INV_NO : 1 Date:10/2/2008
TO : ABC COMPANY
_______________________
S# DESCRIPTION
--------------------------------

1 CUTTER 10.00
2 PENCIL 5.00
3 PEN 2.00


1 PAPER CLIP 4.00
2 RUBBER 3.00
3 STAPLER 8.00
4 PIN 6.00


1 PENCIL 2.00

Evi" wrote:

I see the problem. The word Control means (partly)

anything
that

you
put
in
a report or a form in Design view - lines, fields, text boxes,
labels,
check
boxes etc.
Am I right? You have put in a text box called Line_No?
*This should not be a field in your Query*, just a text box
which
you
drew
there.
When you first put the text box in your report, it will

have
the

word
(Unbound) written in it.
Type
=1
in it.
(this is the same as typing =1 in the Control Source)
When the Properties box is open, click on the tab that says
Data.
One of the lines there will be labelled Control Source.
It should have =1 typed next to it.
Just below that in the Properties box is a line labelled
Running Sum

Click in that and you will see a down-arrow. Here you

can
choose

Over
Group.

There is an example of one of these Running Sum controls

in
the

Detail
section of the Sales By Year report in North Wind

Now, as for the Northwind Invoice report, this doesn't

have
line

numbers
in
it. The field that looks like Line Numbers is a field in the
table
called
Product ID. You will see that if (on a copy of

Northwind)
you

delete
one
of
the products, there will now be a gap in the Line

numbers -
they

won't
be
consecutive (1, 2, 3, 4 etc) but may say something like

2,
4, 7

etc.



Please ask if any of this is unclear.

Evi.






I need line number in detail section. I cant see control
source
there. In
details section I have a field called "LINE_NO" .

In
this

field I
right
clicked to go to properties. I could not see control source
there.
Where
can I go ?

:

If you look back you will see that Alan and I and others
have
done
our
best
to answer your questions and each string of messages has
ended
with
you
NOT
replying to say which bits of our messages you don't
understand.
I will quote the reply I gave earlier to this same question.
Please
be
kind
enough to read it and then tell me which bit of my

reply
you

don't
understand.
How to create Line Numbers:

Put a text box in the section where you want the line
numbers to
go.
Type
=1
next to Control Source in the Properties box
In the Properties box, choose Over Group next to Running
Sum.
Does this give you the results you want?


It is not reasonable to expect anyone to spend the

time
to

write
a
long,
detailed explanation in a newsgroup when you haven't asked a
specific

 

[ak]

Dear Experts,
I have created the invoice database as I want. In case someone else use this
database except me there is possiblity to handle wrong way and as a result it
will screw up. So could you please how to hide tables and how to create to
enter invoice fields. Besides this what are the things to do for safety.
Would appreciate your response.

Hi Ak
Have you tried putting the Invoice Number in the Page Header?
Evi

Dear Evi,
Still I did not know how can I do the following things:
As I told you, I have invoice No.1, 2 and 3.
Each Invoice has multiple pages.
For Invoice No.1 I have 3 pages.
For these 3 pages I need to display Invoice No.1
in each pages.
In Invoice No.2 I have 4 pages.
I need to display Invoice No.2 in each pages too.

Hi Ak
To create a Group Footer:
In the Sorting/Grouping Box, click next to Inv_No
Towards the bottom of the box you will see a grid.
One of the lines says Group Footer
Choose Yes next to this.

To make your page number start from 1 again:
I've had variable success with this so give it a try, ak and let me know
what happens. If it works, at least it is simple to do!

Click on your Inv_No Header (the grey bar in Design View)
In Properties on the Events Tab click next to OnFormat and choose
Event Procedure.
Click just right of that to open a Code page
Just above the line that says End Sub, type
Page = 1

In your page footer, put a text box. Type in it
=[Page]

Note that this method does not work if you set
Repeat Section to Yes in Properties for your Invoice Number header. If that
is what you have done, then you need to put your Invoice Header details into
your Page Header.
Let me know if it works on your report.

Evi



Dear Evi,
I could not get you. I explained in previous posting about page number
very clearly.
How to create group footer? Also I need page number not in all. Need
page
number per invoice only. Invoice No.1 there are two pages. Invoice No.2
there are 4 pages. How can I make invoice Number display this way. Now
displays without grouping. Please explain as you explained clearly in
previous details. Thanks in advance Evi.

:

To put your invoice number on your other pages, as well as in the
invoice
header, put a text box into the group footer and type
=Inv_No
Evi

I could follow your explanation successfully. Now line number
is ok. I need some more favor.

INVOICE NO:
I need invoice number in 2nd page
of invoice. For invoice no.1 in case there is 3 pages need in all
pages
I need the no.1 in page 1, 2 and 3.
For invoice no.2 in case there is 2 pages I need invoice no.2 in page
1 and page 2.

PAGE NO:
My report has page numbers in footer. But I am not getting page
number
per
INVOICE as group. In case Invoice no.1 has 2 pages and Invoice 2 has
3
pages I get page numbers as below:
Invoice No.1 : Page 1 and 2
Invoice No.2 : Page 3 and 5 etc....

Please comment.



:

OK ak. Some of the things I am telling you, you will already know.
But just in case you have missed something out.....
You need to have 1 field which is always different each record. With
invoices this is usually the invoice number.

From the look of your results, you have already used the
Sorting/Grouping
box to group by Invoice Number and you have your Invoice Number and
the
date
in the Group Header

If this is true then check if you also have a Group Footer It may be
called
Inv_No Footer if your field is called Inv_No
If not:
Click on the Sorting/Grouping box on the toolbar.
Choose your Invoice Number field in the list.
Where it says Group Footer, choose Yes.

Close the Sorting/Grouping box
Click on the grey bar which has the name of your footer (perhaps
Inv_No
Footer)
Click Properties
Click on the Format tab
Next to where it says Force New Page, choose After Section.
Does this do what you want?
Evi



Dear Evi,
I want to see 1 invoice at a time. I dont want to see each invoie
on
a
different page as I have now. There is no issue about word
"DESCRIPTION".
I
know those
kind of tricks. Please comment.

:

That's great, it looks like you have successfully added a
Counter
control
Do you mean that you only want to see 1 invoice at a time or
that
you
want
to see each invoice on a different page?
If you just mean that you don't want to see the word Description
then
click
on that control in the report's Design view and delete it.
Evi

I have done as you told me. Let me tell you how my report can
see
now.
I dont want three invoices's description as below.

INV_NO : 1 Date:10/2/2008
TO : ABC COMPANY
_______________________
S# DESCRIPTION
--------------------------------

1 CUTTER 10.00
2 PENCIL 5.00
3 PEN 2.00


1 PAPER CLIP 4.00
2 RUBBER 3.00
3 STAPLER 8.00
4 PIN 6.00


1 PENCIL 2.00

Evi" wrote:

I see the problem. The word Control means (partly) anything
that
you
put
in
a report or a form in Design view - lines, fields, text
boxes,
labels,
check
boxes etc.
Am I right? You have put in a text box called Line_No?
*This should not be a field in your Query*, just a text box
which
you
drew
there.
When you first put the text box in your report, it will have
the
word
(Unbound) written in it.
Type
=1
in it.
(this is the same as typing =1 in the Control Source)
When the Properties box is open, click on the tab that says
Data.
One of the lines there will be labelled Control Source.
It should have =1 typed next to it.
Just below that in the Properties box is a line labelled
Running Sum

Click in that and you will see a down-arrow. Here you can
choose
Over
Group.

There is an example of one of these Running Sum controls in
the
Detail
section of the Sales By Year report in North Wind

Now, as for the Northwind Invoice report, this doesn't have
line
numbers
in
it. The field that looks like Line Numbers is a field in the
table
called
Product ID. You will see that if (on a copy of Northwind)
you
delete
one
of
the products, there will now be a gap in the Line numbers -
they
won't
be
consecutive (1, 2, 3, 4 etc) but may say something like 2,
4, 7
etc.



Please ask if any of this is unclear.

Evi.






I need line number in detail section. I cant see control
source
there. In
details section I have a field called "LINE_NO" . In
this
field I
right
clicked to go to properties. I could not see control
source
there.
Where

 

[Evi]

I can tell you a couple of simple things which you can do. Others may have
more tips
1.) To hide queries etc, right click on them when they are closed. Go to
Properties, click Hidden.
Go to Tools, Options, View and untick Show Hidden Objects.

2. Open up any code module in your database and go to Debug, Compile...
This will check that there is nothing wrong. Clean up any errors it finds.
Close the Module. Go to Tools, Database Utilities, Compact & Repair
Now make a copy of your database to back it up and remember to back it up
regularly.

3. Now, in your main database window, go to Tools, Database Utilities,
Database Splitter. This will split your database in 2. Your other users can
use the Front End (this contains forms, queries, reports). You can make as
many copies of this as you want.
You can keep the backend which contains the tables. This way, users can't
enter data directly into tables and mess up any safety checks within your
forms.
Evi

Dear Experts,
I have created the invoice database as I want. In case someone else use this
database except me there is possiblity to handle wrong way and as a result it
will screw up. So could you please how to hide tables and how to create to
enter invoice fields. Besides this what are the things to do for safety.
Would appreciate your response.

Hi Ak
Have you tried putting the Invoice Number in the Page Header?
Evi

Dear Evi,
Still I did not know how can I do the following things:
As I told you, I have invoice No.1, 2 and 3.
Each Invoice has multiple pages.
For Invoice No.1 I have 3 pages.
For these 3 pages I need to display Invoice No.1
in each pages.
In Invoice No.2 I have 4 pages.
I need to display Invoice No.2 in each pages too.

:

Hi Ak
To create a Group Footer:
In the Sorting/Grouping Box, click next to Inv_No
Towards the bottom of the box you will see a grid.
One of the lines says Group Footer
Choose Yes next to this.

To make your page number start from 1 again:
I've had variable success with this so give it a try, ak and let me know
what happens. If it works, at least it is simple to do!

Click on your Inv_No Header (the grey bar in Design View)
In Properties on the Events Tab click next to OnFormat and choose
Event Procedure.
Click just right of that to open a Code page
Just above the line that says End Sub, type
Page = 1

In your page footer, put a text box. Type in it
=[Page]

Note that this method does not work if you set
Repeat Section to Yes in Properties for your Invoice Number header.

If
that

is what you have done, then you need to put your Invoice Header

details
into

your Page Header.
Let me know if it works on your report.

Evi



Dear Evi,
I could not get you. I explained in previous posting about page number
very clearly.
How to create group footer? Also I need page number not in all. Need
page
number per invoice only. Invoice No.1 there are two pages.

Invoice
No.2

there are 4 pages. How can I make invoice Number display this

way.
Now

displays without grouping. Please explain as you explained clearly in
previous details. Thanks in advance Evi.

:

To put your invoice number on your other pages, as well as in the
invoice
header, put a text box into the group footer and type
=Inv_No
Evi

I could follow your explanation successfully. Now line number
is ok. I need some more favor.

INVOICE NO:
I need invoice number in 2nd page
of invoice. For invoice no.1 in case there is 3 pages need

in
all

pages
I need the no.1 in page 1, 2 and 3.
For invoice no.2 in case there is 2 pages I need invoice no.2

in
page

1 and page 2.

PAGE NO:
My report has page numbers in footer. But I am not getting page
number
per
INVOICE as group. In case Invoice no.1 has 2 pages and

Invoice 2
has

3
pages I get page numbers as below:
Invoice No.1 : Page 1 and 2
Invoice No.2 : Page 3 and 5 etc....

Please comment.



:

OK ak. Some of the things I am telling you, you will already know.
But just in case you have missed something out.....
You need to have 1 field which is always different each

record.
With

invoices this is usually the invoice number.

From the look of your results, you have already used the
Sorting/Grouping
box to group by Invoice Number and you have your Invoice

Number
and

the
date
in the Group Header

If this is true then check if you also have a Group Footer

It
may be

called
Inv_No Footer if your field is called Inv_No
If not:
Click on the Sorting/Grouping box on the toolbar.
Choose your Invoice Number field in the list.
Where it says Group Footer, choose Yes.

Close the Sorting/Grouping box
Click on the grey bar which has the name of your footer (perhaps
Inv_No
Footer)
Click Properties
Click on the Format tab
Next to where it says Force New Page, choose After Section.
Does this do what you want?
Evi



Dear Evi,
I want to see 1 invoice at a time. I dont want to see

each
invoie

on
a
different page as I have now. There is no issue about word
"DESCRIPTION".
I
know those
kind of tricks. Please comment.

:

That's great, it looks like you have successfully added a
Counter
control
Do you mean that you only want to see 1 invoice at a time or
that
you
want
to see each invoice on a different page?
If you just mean that you don't want to see the word Description
then
click
on that control in the report's Design view and delete it.
Evi

I have done as you told me. Let me tell you how my

report
can

see
now.
I dont want three invoices's description as below.

INV_NO : 1 Date:10/2/2008
TO : ABC COMPANY
_______________________
S# DESCRIPTION
--------------------------------

1 CUTTER 10.00
2 PENCIL 5.00
3 PEN 2.00


1 PAPER CLIP 4.00
2 RUBBER 3.00
3 STAPLER 8.00
4 PIN 6.00


1 PENCIL 2.00

Evi" wrote:

I see the problem. The word Control means (partly) anything
that
you
put
in
a report or a form in Design view - lines, fields, text
boxes,
labels,
check
boxes etc.
Am I right? You have put in a text box called Line_No?
*This should not be a field in your Query*, just a

text
box

which
you
drew
there.
When you first put the text box in your report, it

will
have

the
word
(Unbound) written in it.
Type
=1
in it.
(this is the same as typing =1 in the Control Source)
When the Properties box is open, click on the tab

that
says

Data.
One of the lines there will be labelled Control Source.
It should have =1 typed next to it.
Just below that in the Properties box is a line labelled
Running Sum

Click in that and you will see a down-arrow. Here

you
can

choose
Over
Group.

There is an example of one of these Running Sum

controls
in

the
Detail
section of the Sales By Year report in North Wind

Now, as for the Northwind Invoice report, this

doesn't
have

line
numbers
in
it. The field that looks like Line Numbers is a

field in
the

table
called
Product ID. You will see that if (on a copy of Northwind)
you
delete
one
of
the products, there will now be a gap in the Line numbers -
they
won't
be
consecutive (1, 2, 3, 4 etc) but may say something

like
2,

4, 7
etc.



Please ask if any of this is unclear.

Evi.






I need line number in detail section. I cant see control
source
there. In
details section I have a field called "LINE_NO"

..
In

this
field I
right
clicked to go to properties. I could not see control
source
there.
Where