query help

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.
 
E

Evi

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can a query do ... 2
Union Query question 1
Making a non updatable query into an updatable query 1
Transferring Data 3
Update query with IIfs? 6
Multiple parameter query 2
Compare two tables and write results to third table 9
Complex group and sort query to find top record for each group 1

Top