How can I set up the same report using different tables in Access

D

decoho

Each month I type information into a table. The data in the table is
different from month to month, but the report is essentially the same. How
can I utilize the same report, but with a different table each month?
 
D

Douglas J. Steele

You shouldn't have a separate table each month. Instead, you should have one
table, with a Month column in it. Then, you can create a query that prompts
for the month, and only returns that month's worth of data.
 
M

mickeywks

You can change the source of data. In design mode, click on the gray square
left of the ruler(little black box will appear). Right click to get
properties and in either the Data tab or All tab, change the Record Source
to the table you want.
 
Top