A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

report number



 
 
Thread Tools Display Modes
  #1  
Old February 22nd, 2006, 12:10 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default report number

Hi I need to get 3 reports out of the same data and they mainly have the
same data.
But they need to get a unique number based on the date and then 3 different
numbers (one for each report) for the same data, to be continued per sets of
three and it needs to restart at 1 every day.
is this possible at all?
thanks,
Patrick


  #2  
Old February 22nd, 2006, 01:00 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default report number

Your post is very confusing. Can you give us an example of what this number
should look like? Is this number in the report header, or are you trying to
apply it to each line on the report? What is the purpose of this number?
What happens if you print a given report more than once in a day?


--
Rick B



"Pat" wrote in message
...
Hi I need to get 3 reports out of the same data and they mainly have the
same data.
But they need to get a unique number based on the date and then 3
different numbers (one for each report) for the same data, to be continued
per sets of three and it needs to restart at 1 every day.
is this possible at all?
thanks,
Patrick



  #3  
Old February 22nd, 2006, 03:11 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default report number

the number is just a 2 digit number
it is not a report number / page number it is a reference number for other
people that use the hard copy only

the data is used for 3 similar but different (in output) reports and each
has to have a different number as it is being used as reference. now it is
done manually but I would like it to be done when printed.
I use 3 pages for each set of data the result is only 3 pages each time.
there are more then one inputs per day that multiplies in those different
forms and the number just counts on
data 1 rep 1= 01
data 1 rep 2= 02
data 1 rep 3= 03
data 2 rep 1= 04
data 2 rep 2= 05
data 2 rep 3= 06......
Tks,
Pat



"Rick B" Anonymous wrote in message
...
Your post is very confusing. Can you give us an example of what this
number should look like? Is this number in the report header, or are you
trying to apply it to each line on the report? What is the purpose of
this number? What happens if you print a given report more than once in a
day?


--
Rick B



"Pat" wrote in message
...
Hi I need to get 3 reports out of the same data and they mainly have the
same data.
But they need to get a unique number based on the date and then 3
different numbers (one for each report) for the same data, to be
continued per sets of three and it needs to restart at 1 every day.
is this possible at all?
thanks,
Patrick





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
page number positioning and format tinaa Page Layout 3 February 4th, 2006 12:38 AM
Microsoft Access Limits (file size, table records, users) Mike General Discussion 4 November 4th, 2005 03:01 AM
help needed jkendrick75 Running & Setting Up Queries 19 March 17th, 2005 02:37 PM
Number of objects thomak General Discussion 3 February 17th, 2005 11:58 AM
incorrect sums in report using 2 tables jkendrick75 Setting Up & Running Reports 22 December 13th, 2004 02:19 PM


All times are GMT +1. The time now is 11:44 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.