simple report question (i hope)

[knaya]

i want to be able to do a report based off a table but i want to be able to select what records to print basesd on the date i enter.. e.g if i enter 1/01/03 to 30/01/03, i want the report to show all transactions for that day.. how can i do this?

 

[sxschech]

You might consider running the report off a query, then you can put a prompt in the query to allow the user to specify the date range for the report. Under the date field in the criteria row type the folling including the brackets:

Between [Enter Start Date:] and [Enter End Date:]

You can change the prompt that appears by using different wording within the brackets. Also, remember to change the Record Source in the report to point to the query rather than the table.

 

[knaya]

sxschech , it workeddd.. thank youu, it shoews the transactions.. but i would like for it to calculate the profit at the end of the report.., how can i do that..your assistance is much appreciated

 

[sxschech]

If you already have a field on your report then you can copy it and paste it into the report footer. If the report footer isn't visible, click on View Report Header/Footer first. Then edit the text box Control Source. For example if the field name is Profit, the control source after being edited will display as follows:

=Sum([Profit])

If you need further information, let me know.