Query on last sheetID number

  • Thread starter Thread starter Rick Patterson
  • Start date Start date
R

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.
 
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
 
Thanks That Worked Great!!!!
Gerald Stanley said:
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
Click to expand...
 
Back
Top