parameter query

[Guest]

can I use a parameter query to select the table for a query? My table names
change each month when I add new ones based on date. But - structure is
always the same.

 

[John Spencer]

No, you cannot.

You would have to use VBA to write the SQL statement.

 

[Jeff Boyce]

?Your table changes its name each month? This doesn't sounds like a
well-normalized design. It sounds like a ... spreadsheet. Why not add each
month's data into a single table?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/