query help

  • Thread starter Thread starter joseph atie
  • Start date Start date
J

joseph atie

I need some help with an update query.

What i have is 4 fields in a table (project code, Section
no, DWG no and revision no) I also have a status field
and a date recieved field,

what i need is an update query that will determine the
most current revision (based on date) for each dwg no for
each section for each project, and update its status
field to current

Any help would be great becuase I dont know where to
start on this one.
 
Make 2 queries. One has DWGno and Date Received. Press the Totals key in
Query Design and choose Max under Date Received.
Make a normal query from your table which includes your DWG no. Field,
DateRec and Status. Add the Max Date query to the query grid. Link the two
queries by the DWGNo field and the DateReceived Field. Change the query into
an update query and put the required update under Status.
Evi
 
Back
Top