Selecting table name from current date in Access DB

[Perilous1]

I am creating a job calendar and I want to have a separate table in an access database for each day. The simplest solution seems to be to just name each table as the current Calendar1.Value

I am having trouble however determining how best to query a table name based on a variable with a date string.

Please bear in mind, all of my SQL statements are in DataEnvironment commands rather than in code.

Any help with this would be greatly appreciated.

 

[SkipVought]

Hi,

Your moniker portends you proposed process.

http://support.microsoft.com/kb/283878

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Andrzejek]

This is a VB5 & 6 forum, you have data base / Access related question, so you are in the wrong forum.

I want to have a separate table in an access database for each day

Bad, bad, bad idea.
You are breaking several rules of relational data base design with this approach.

Have fun.

---- Andy