Hello,
I am using Access 2003 (limitations where i work on versions that can be used) and trying to create a create a query from a table names that change each month.
For example, table called EOM Costed Jan19 will be called EOM Feb19 and EOM Mar19 and so on. Of course the month and year is at the end of each table name.
The table structure remains the same each month, just that every month there is a new one. I would like to create a query that will prompt for the table name and another prompt for a user ID that can be run from any station as the database is stored on the network. I would also like to include about 8 fields from said table, those fields will be the same each time I run it.
I am not a programmer though I see quite a few VB codes in the program already, so it is not strange, just not savvy much on VB.
I can do basic queries and join tables, but this is out of my realm.
I should add that I am using Windows 7 with office 2007, but i can create the query in office 2003 access which is where the database was created on a 'work' pc.
Thanks for any help.