Printable View
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.
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.