Append or Join table in Access vba
Posted on 2009-04-15
I have access program that input data from text file into the access table, (fixed sturcture table)
Every time input data routine is run (data from different stores), it create table with storename+date name (As wanted). And when report is generated it has data from table.
Report take that table as record source.
What needs to done is that
1 - if input data is run for four store (could be more). Report should have data from all four store.
Problem = how to combine or link all 4 table into one and set that as record source for repot?
Data is huge, so if there is a way to link all table, instead of appending it into one query will have database size grows twice (if possible)
2 - if possible to have option to display one store selcted or all store in report using combobox.
Any help ?