Brain dead

[fixious123]

Although probably an easy fix I cant seem to find this with my knowledge level. Im trying to find the latest (most recent) date from two different fields on a table. One field is M16AFQC and the other is M16TRQC. How would I go about doing this. Thank you..

 

[dcx693]

It depends on how you want the data returned to you.

1- use a DMax function to pull the data from both tables and compare the two.

2- use ADO or DAO code to pull the max from a sorted recordset

3- Use a top values query to pull the largest values

 

[fixious123]

I've tried to piddle around with Top values but to no avail. Any help is greatly appreciated..Thanks

 

[dcx693]

For the top values query, group on the date field and choose Max, or Last, I think.

 

[fixious123]

Im preety new and didn't understand what you wrote. Could you break it down for me? THanks

 

[fixious123]

Ok making progress but I want to send the most recent date from those two fields to one text box on a report. Is this possible?

 

[dcx693]

As I said in my first post: the method you choose depends on how you want the data. If you want the two dates on a report, then try method (1).