How can I choose which table should report show?

[Crazy]

So, I made one table called shipments, and a report based on that table.
I receive each day excel sheets with datas which I would like to get in same
report as above mentioned
when i import that excel file in database, it creates a new table.
so, now my question is how can i get in inquiry when openning an report to
ask me which table do i want for report?

to consider is:
- i need those reports separately for each excel file
- report is used basicly as "printing tool" - something like delivery note,
meaning each line in excel file is delivery note which I must print in
certain format (which I made in report), and sometimes I can have upto
120lines per excel file.

pls if some1 has any solution, I would appretiate a lot!

THANKS!

 

[Crazy]

So, I made one table called shipments, and a report based on that table.
I receive each day excel sheets with datas which I would like to get in
same report as above mentioned
when i import that excel file in database, it creates a new table.
so, now my question is how can i get in inquiry when openning an report to
ask me which table do i want for report?

to consider is:
- i need those reports separately for each excel file
- report is used basicly as "printing tool" - something like delivery
note, meaning each line in excel file is delivery note which I must print
in certain format (which I made in report), and sometimes I can have upto
120lines per excel file.

pls if some1 has any solution, I would appretiate a lot!

THANKS!

also, maybe there is a way to bind a report from access directly with excel
sheet (so that there is no need to import excel sheet in access and create
allways new tables?)

 

[KARL DEWEY]

maybe there is a way to bind a report from access directly with excel sheet
You can link Excel instead of importing.

Why not append each Excel instead of importing? Then use date criteria for
the report.