Max Date on report

[1koppp]

Hi, I am trying to sort a table of work requests with several columns of dates to find the latest date of those listed. I have tried ascending order in the query, but it doesn't really do what I want it to. Ideally this 'maxdate' would then be stored back in the table in another column. The date is only needed for display in a report, so its not crucial to save it, though. Sorry if this seems like a rookie question, Pete

 

[1koppp]

GOT IT!. I removed tbl in front of the table name. Sorry, I didn't title my objects like that.
OK, so I have the union query working, will make the followup query and let you know how it turns out.
Thanks again for your patient assistance,
Pete

 

[dhookom]

Do yourself a favor and find a good naming convention and stick with it. Check Tony Toews page

http://www.granite.ab.ca/access/tablefieldnaming.htm.

Also, read up on normalization.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[1koppp]

Allright. I have the second query working also. The code I typed from above was giving me a "aggregate" fault. I just created a query through design view and grouped by max. (SQL must have been slightly different). Anyhoo, I have it working and can continue on with my many reports.
Thanks for Your Help.
I actually would do quite a few things differently if I started this one over, but being that its my first actual database, I think I've done OK. I think table building is easy to catch onto, but I learned a lot from creating the queries, forms and reports.
Take Care and Good Typing,
Pete