Sales Report for monthly and Anually

[KiraObito]

Hey.
I want to make a Sales Report for monthly.. For example the sales report for March . And also i want another report to make the Annual Sales Report which will show all the sales record for that particular year..

And ideas.. Please help me

Thank u in Advance

 

[dhookom]

I would create a form with controls for the user to enter start and end dates. Use these to build the WHERE CONDITION of the DoCmd.OpenReport method.



Duane
Hook'D on Access
MS Access MVP

 

[KiraObito]

can u give me a sample code? and does i have to do it in VB in Access or in the builder?

Thank You

 

[dhookom]

Please provide the name of the report as well as the name of the date field in the report's record source.

Duane
Hook'D on Access
MS Access MVP