Report Filter Help

[h755bpx]

I am fairly new to MS Access but have managed to program a basic database for my employers.

The database basically is split into 2 forms, Product Quotes and Service Quotes, both forms accessible directly from the switchboard.

On the forms themselves, the Sales Rep, Status, Branch and Supplier are drop down boxes, receving their data from another table, and a "Complete" check box, which quite simply, is ticked if the order has been fulfilled and is not ticked if not yet finished.

Also, there is a section on the forms in the form of a text box highlighting Cost Price, Sell Price and Gross Profit.

What I want to be able to do, is create a report tool that will be able to report the following:

(a) Orders not yet complete by Sales Rep
(b) Orders by sales rep over a period (and be able to select what period)
(c) Gross Profit against Cost over a period of time

I can program forms no problem, but the Report Wizard is really not very good and only allows very basic reports.

If possible, please explain how to do this in as "lamen" as possible!

Thanks in advance!

Jon

 

[shudini]

the easiest way to explain without any programming would be to create separate queries for each of your desired filtering options, for example
SELECT * FROM YourDataSource WHERE NOT [Complete]
If you build a report on this data, you will only get not complete.

Same with the other reports, except you would create a parameter query that would prompt you to input dates or values, which would in turn filter the data on the fly.