Report with Argument

[Sunny]

Hi all,

Acess is new to me. I just started it. I am asked to create report which is
simple but I dont know how to do it. Report is about sales figure on
particular date. This date should be entered by the user. What I want to do
is

1. Create one form (user interface) to ask a date
2. pass the date to report (sales report)
3. read argument in the report
4. run the sql filtering with the passed date
5. Display data

Run step 1 to 5 with different dates until user press the exit button on
user interface form.

Any help would greatly appriciated.

Thanks.

 

[Cynthia]

Wow! You really will need a basic Access book. What you
want to do is very simple but requires a number of steps
and ANY book will get you started:

1. You need to have a TABLE that contains all the sales
data.
2. The DATE must be a field in the TABLE, that is, each
sale must have a date.
3. From the table you will create a FORM with a TEXT
control to enter the date and a COMMAND button to run the
report.
4. You must design the REPORT's layout.
5. You will then create a QUERY based on the FORM. The
query will use the DATE the user input to generate the
REPORT.
6. Pressing the Command Button on the FORM will cause the
query to run and open the REPORT.

 

[Sunny]

I understand upto step 5, but how do I pass query result to report? or any
other way?

My report is ready but I am using current date for the querey now I want to
pass user entered date. Can you please be more specific?

Thanks.