Query on last sheetID number

[Rick Patterson]

Access 2002
I have a table called JobSheet and one called JobDetails. The JobSheet
references several JobDetail records. (In other words JobSheetID 31 may
reference 10 JobDetailIDs) I am building a querry in design viewthat will
deliver summary information on all of the data in JobSheetID 31. I can make
this work by using a parameter query but I would like to have the querry
just look at the last entered JobSheetID rather than ask me which JobSheetID
I want to look at.
Is there a way to do this in the criteria field?
I hope I made sense with my request.

 

[Gerald Stanley]

If the JobSheetIds are issued in ascending order, you could
put the following in the JobSheetId criteria field

= (SELECT Max(JobSheetId) FROM JobSheet)

Hope This Helps
Gerald Stanley MCSD

 

[Rick Patterson]

Thanks That Worked Great!!!!

If the JobSheetIds are issued in ascending order, you could
put the following in the JobSheetId criteria field

= (SELECT Max(JobSheetId) FROM JobSheet)

Hope This Helps
Gerald Stanley MCSD