Drawing monthly reports

[raketekc]

hi guys,

i want to draw a report for quotations for each month from an access database table which contains all quotations made from the time the program was installed. i want the user to click on the month e.g September, then a report is generated for the month of September. Note that not all days in the month have quotation entries.

Please help.

[Ecniv]

either make a query or have a reporting table ready. If you go for a table you need to delete all records from it first.

Then you fill it with the specified month/year totalled quotes. This would be an insert into (append) query, which does all the totalling for you (use the E button)

Then make a report that reads that table.

The above is one option - the other is to have a select query (mentioned above)to pull in the required data, but you'd probably need to read up on parameters.