[mso] Re: Access Report Line numbers

Thank you for the tip, I'll give it a go.
Ron
  ----- Original Message ----- 
  From: Cathy.Evans@xxxxxxxxx<mailto:Cathy.Evans@xxxxxxxxx> 
  To: mso@xxxxxxxxxxxxx<mailto:mso@xxxxxxxxxxxxx> 
  Sent: Thursday, July 27, 2006 9:11 PM
  Subject: [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<mailto:cheshierron@xxxxxxx>>      
                                                                              
                         Sent by:                                               
                                               To 
                         mso-bounce@freelists<mailto:mso-bounce@freelists>.     
    "Access User Group" <mso@xxxxxxxxxxxxx<mailto: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<mailto:mso@xxxxxxxxxxxxx> or 
MicrosoftOffice@xxxxxxxxxxxxxxx<mailto:MicrosoftOffice@xxxxxxxxxxxxxxx>.

  To send mail to the group, simply address it to 
mso@xxxxxxxxxxxxx<mailto: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<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<mailto: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<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<http://personal-computer-tutor.com/abc3/v28/greg28.htm>
  *************************************************************

*************************************************************
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: