MS Access Query: Creating a Master table from premade query that selects records with most recent date

Question

I'm trying to make a master table in ms access that constantly updates the records of the unique model numbers based upon the most recent date.

The premade table was created by using a select query that brings all the records of multiple tables and inserts them into a single table. Within each table there are multiple fields however the only relevant fields are the Model number field and the Date. Across the tables the unique model numbers are repeated, but their individual time stamps are different.

I need the master table to select the records with the most recent date and place the whole record into the master table. I'm new to ms access and I don't know how I could do this. Any tips of suggestions would be most appreciated.

To get useful feedback you need to provide formatted table layouts with field names and data types you want in your select - and some basic example data showing what you have and what you want out of the query. — dbmitch
@dbmitch Yes, that is what I ended up figuring out, along with some SQL. — Charlie West

Rene Rene · Accepted Answer · 2016-07-12T21:52:31

If you would need such a table then I'd say there's definitely something wrong with your database design. Having said that, why don't you query on the most recent date of tables that hold Model Numbers? It might help if you could elaborate on why you'd want to do this, as in why you have multiple tables that hold Model Numbers. Maybe your current database design is open for improvement.

Kind regards,

Rene

MS Access Query: Creating a Master table from premade query that selects records with most recent date

1 Answers