invoice line items

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hey all,

can someone please tell me how to number my line items in my report?
e.g.
1. Product#1
2. Product#2

Is this something easy i can do?

thanks,
rodchar
 
You can create a text field, in the control source of the field write
=1
And set the running sum of the field to yes
 
Is this something easy i can do?

Of course. Create two new text boxes in the Detail section of the report.
Open the Properties dialog window and select one of these text boxes. Name
it txtNum. Select the "Data" tab and select the Control Source Property.
Type:

=1

(No spaces.) Select the Running Sum Property and select Over All in the
combo box. Select the "Format" tab. Change the Visible Property to No.

Select the other text box and place it in the Detail section where you want
the Product# to show. Select the "Data" tab and type:

="Product#" & [txtNum]

Close the Properties dialog window and save the report. Open it and you'll
see Product#1 for the first item in the Detail section, Product#2 for the
second item, and so on.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
Back
Top