[mso] Re: Access Report Line numbers

Not elegant and someone may have better way, but in your report
recordsource, you could create a field in the query like Count: "1", which
will return a value of 1 for every line item.  Then in your report sorting
and grouping, you have to have the header OR footer set to yes for the
field you have as your main item.  I prefer the header because it looks
better.  There you would place a text box with the control source set to
=Count([Count]) and the running sum property set to 'over all'.

You were on the right track counting records and adding one, I believe this
will accomplish it for you . . . at least it worked in my test!

Cheers :)


                                                                                
                                                
                       "RONALD CHESHIER"                                        
                                                
                       <cheshierron@xxxxxxx>                                    
                                                
                       Sent by:                                                 
                                             To 
                       mso-bounce@freelists.         "Access User Group" 
<mso@xxxxxxxxxxxxx>                                    
                       org                                                      
                                             cc 
                       07/27/2006 11:43 PM                                      
                                                
                       Please respond to mso                                    
                                        Subject 
                                                     [mso] Access Report Line 
numbers                                           
                                                                                
                                                
                                                                                
                                                
                                                                                
                                                
                                                                                
                                                
                                                                                
                                                
                                                                                
                                                
                                                                                
                                                


Hi folks, hope all are well.
I need a little help with an ACCESS report I have designed.  The report is
used to order items for my Laboratory.  It is a table format.  If I order
more than one item from a supplier the table contains each item with it's
catalogue number, description, cost, etc.  I would like to be able to
automatically add a line number for each item and the line number would
only exist if there is an item. So, if I had 5 items on my list there would
be a cell for each showing 1,2,3,4 and 5 ( but no 6 as there are only 5
items). I have tried set up a text control that uses a formula like N=N+1
with N=0 as a start point but that doesn't work.
Anyone have any suggestions.

Thanks for the help.

Ron




-----------------------------------------------------------------------------------------------------
The information transmitted is intended only for the person
or entity to which it is addressed and may contain proprietary,  
business-confidential and/or privileged material.
If you are not the intended recipient of this message you 
are hereby notified that any use, review, retransmission, 
dissemination, distribution, reproduction or any action taken
in reliance upon this message is prohibited. If you received
this in error, please contact the sender and delete the 
material from any computer.  Any views expressed in this message
are those of the individual sender and may not necessarily reflect 
the views of the company.  
-------------------------------------------------------------------------------------------------------

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: