Query to give most Recent record with multiple tables

[bdacct]

First I would like to state that I’m just an Accounting/MIS Intern who got stuck with this so I’m a little lost. And need some help with the last step.

I have three tables:
Master_File
Imported_Responses
Updates

I need to somehow create a query to give me the most recent records for a particular Audit and Action Plan. I have two primary keys in the Master file Audit_Number and Action_Plan_Number because you can have multiple plans per Audit. We get responses on the Current_status of the audits multiple times and make multiple Updates to the file throughout the process. But I need information from all three tables in my report but only the most recent response and most recent update. Currently it is giving me duplicate records for each Imported Response and each Update.

Thanks.

 

[lespaul]

What does your query look like? Please provide sample data and expected results (this will make it easier to figure out what needs to be done)



Leslie
landrews@metrocourt.state.nm.us

There are 10 types of people in the world -
those who understand binary
and
those who don't!