Too many times asked before print or review Access 2000 Report

[wdacc]

I have two tables. They have date files. I need info form 8/11 to 8/12 from table 1 and also info 8/11 to 8/12 from table 2. So I made two querries. Each of them has a command " Is Not Null and Between Beginingdate and Endingdate" I use two querries to make a new form with "Autoform: Tabular". One of squerry is to be added as subform and placed in "Form Footer" I satisfy the report, but the problem is before I review the report I have to input three sets of times data input ,( begining data 8/11, ending date 8/12,{form table 1} begining data 8/11, ending date 8/12,{from table 2} begining data 8/11, ending date 8/12,{ from table 2}) then I decided to print the report, I have to repeat those input again to get printed report.
Is there any expert giving me some solutions to solve the problem? thanks !

 

[GingerR]

create a form. Call it for example, "MAIN"
put on two text boxes, name one txtDateFrom and the other txtDateTo. Make them format "mm/dd/yy" or Short Date or whatever you want.

in all of your query criterias, put instead:

forms!Main!txtDateFrom
or
forms!Main!txtDateTo

whichever is appropriate

then make a button. you can use the wizard make it open your report.

then fill in your dates and hit the button.

hope this helps.

g

 

[hermannd]

The advice that you gave him will work, but the underlying problem still hasn't been solved. Why does it prompt you for this user input again in order to print the report. Should it not just take the info you have in preview and send it to the printer? or am I being to realistic.

 

[wdacc]

I tried it didn't work. The report is for most employee to share and for some who need print it out. It seems it is the only way I can do is put one querry in form detail and one in form footer because I need two groups of data and both have date for people to search for. Eg. If one buys 10 apples every day and put info colors and diameters, and also he buys 10 banannas and put info weight and ength. The report is wanted to show both apple and bananna info on some specific date--like yesterday and today. What I did is I make two tables -- apple and bananna, then make two corresponding querries and put criteria " between [tab-1][Date-1][beginingDate] and [tab-1][Date-1][EndingDate]" and between [tab-2][Date-2][beginingDate] and [tab-2][Date-2][EndingDate]", then I make a form by using "Auto Form: Tabular" Table-1 info on form detail, table-2 info on form footer. When I click the form, I need input begining date and ending date for both table. That's excellent. I can get what I want, even different dates on table-1 and table-2. But the problem is how to send report via email to my colleges. I save the opened form as report form. and click the report. But I need input begining date and ending date three times ( total 6 inputs) and also after I preview the report, and chose snapshot and send email, I need input begining date and ending date twice (total 4 inputs). Now I hope you- all experts understand my problem.