Database and Excel Spreadsheets

[classhandicapper]

Originally Posted by Track Collector

It was not clear to me exactly what you proposed, but I played around, and now it looks like I have what I want in a much quicker process.

THANK YOU!!!

That's what we like to hear.

[Exotic1]

Originally Posted by sjk

If I understand you correctly just make a table out of the list of dates, tracks and races that you want to query.

Create another query with the original query and the new table where the fields are joined.

The results of this query would seem to be what you need.

A one-off on this would be to upload the Date/Track/Race# filtered query result into a temp table if you wanted to add fields or update.

[jazzfan]

I am not sure I understand exactly what you require, but perhaps the SQL command UNION is what you are looking for? You can combine the result sets of many different queries into one result set https://support.office.com/en-us/art...0-ad0a75541c6e