Action queries are actually much harder than basic select queries!
I can help you do what you need to do, even come up with the code you need, if you just give us a few more details (that information would also be needed to do an Action Query anyway).
This may actually be even easier than I first thought based on the answer to the following question.
This Max Date you are looking for, is it for a particular group, or is it just one Max Date for everyone in the whole table?
That is, are you just looking for the Maximum Date in the WHOLE column (not Grouping by any other fields), and want to know if a particular person has this value in their date field?
If so, that can be done with a real simple query. Just do the following:
1. Remove the Current field from your table, you do not need it.
2. Create a new query adding all the fields you want to export, except for this "Current" field.
3. Add the following calculated field to your query:
Code:
Current:IIf([Report Date]= DMax("Report Date","MK TBL MGMT Report Shells with Dates"),"Yes","No")
4. Save your query
Check it out, and it should return what you want.
Now, all you have to do every time you import new data is export this saved query! No need to run any Action Queries first!
So hopefully, that makes your life a little simpler and less headaches!