Report (Different Table References)

[MayoRR5]

Hi guys,

I have 12no. tables containing days for all the months of the year. I know this is against normalization rules but I couldn't get around this format. I needed a timesheet that mirrored the screenshot attached.

Now I want to create one report that will pull data from a specified table (the selected table will be controlled by a textbox)

Thanks in advance!

Shaun

 

[Rich]

There's no screenshot

 

[MayoRR5]

Woops, sorry!!

It's attached now.

 

[MayoRR5]

Woops, it's attached now.

 

[nileflower]

first as you want to use 12 tables
rename tables to be the same name but ends with no from 1 to 12
like this table1,table2....
then
all tables must be on the same design and data format
then crate a report using report wizard on one of this table
create a form that contains a combo box of numbers from 1 to 12
create an event on this combo box after update
contain a code like this
tabename=table+me.combo

report(name).datasourec=table
----
and if you attache a database contains tables only
i can help