axa
|
| Posted: 08/11/2002, 9:27 PM |
|
my Accass database file contains many similar tables (snapshots of clients' information at the end of each month). Tables are named like months.
How can I put the name of the table into the SQL string (Select ... From varMonth) using CodeCharge?
For now I had to do it by hand afterwards.
I know that with Where clause it can be done through CC.
|
|
|
 |
Ken Hardwick
|
| Posted: 08/11/2002, 11:05 PM |
|
You can do this in the custom SQL..
something like...
Select
Field1,Field2,Field3
From " & session("tableName") & "
Or in the before open event...
sSQL = "Select Field1,Field2,Field3 from " & session("tableName")
|
|
|
|
|
