Sort Order in Reports

[Guest]

Hello All

Could anybody please help with the following Problem

I have 3 reports based on the same query, 2 of the reports produce complete lists of all the items in the query sorted b
ReqdDate, and then ProdDate. The third report produces a job card for each of the enteries in the query
My problem is how do I number each record on the ReqdDate report (1 to ????) and then print the same number on the ProdDate and JobCard Reports

Many Thanks

Derek

 

[Bruce]

I have been attempting something of the sort. At
www.rogersaccesslibrary.com there is a sample database
called AutonumberProblem2k.mdb that might point you in the
right direction.

-----Original Message-----
Hello All'

Could anybody please help with the following Problem,

I have 3 reports based on the same query, 2 of the

reports produce complete lists of all the items in the
query sorted by

ReqdDate, and then ProdDate. The third report produces a

job card for each of the enteries in the query.

My problem is how do I number each record on the ReqdDate

report (1 to ????) and then print the same number on the
ProdDate and JobCard Reports.