Hi all! I have few beginner questions i don't find answers to.
Can i use one report template to all my queries?
How do i import my new query data to my report template?
If i make changes to query, how can i refresh the data to report?
Hi all! I have few beginner questions i don't find answers to.
Can i use one report template to all my queries?
How do i import my new query data to my report template?
If i make changes to query, how can i refresh the data to report?
What do you mean by 'all my queries'? Are these queries all the same data and just applying different filter criteria?
What changes? Just filter criteria?
Review http://www.datapigtechnologies.com/f...mtoreport.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Yes, all the queries i want to make is from the same data, using different filter criteria.What do you mean by 'all my queries'? Are these queries all the same data and just applying different filter criteria?
What changes? Just filter criteria?
Review http://www.datapigtechnologies.com/f...mtoreport.html
Can i create new queries, then import that to my old report template, if the filters are the same on both formulas?
How do i exactly do this? Create query, then save it, then open my report template and it opens report with query data i made?
Or do i have to open the query first, then open my report template?
I can't test this since i'm on holidays and can't "access" my working computer.
I assume i could just edit the query i have, but i want to keep list on what i have done, so i need them saved separate for later use.
Thanks for replying, i really appreciate it.
-Esko
Did you review the tutorial in the link? It is one way to open report with different filter criteria.
I am not sure what you mean by 'import to old report template'. What do you mean by 'keep list'?
A query does not have to be 'opened' for data to display on report. A report has a RecordSource that uses a table or query. Just open the report.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.