How can I choose which table should report show?

  • Thread starter Thread starter Crazy
  • Start date Start date
C

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 said:
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?)
 
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.
 
Back
Top