filtering a query

[M]

I am new to access.

I am trying to prepare a database which will be used by my collegue to
montor supplier information.

There is a table for suppliers details.

Then a table for the delivery details, controller and haulier for each
depot. This is necessary as some controllers look after specific depots,
however normally a controller would look after all ten depots for a
supplier. The same situation applies to the goods hauliers.

What i want to do is to create a report which shows which suppliers are
ordered by each controller. However when i run this report each supplier
can appear up to ten times for each controller. This is the problem.

What I want to know is can I somehow filter this data out using a query so
that the supplier appears only once for each controller?

thanks in advance,

 

[Guest]

You need to look up help on how to use grouping in your reports. Use the
report wizard to create you report and in the step that asks if you want to
add any grouping levels, select suppliers.


Thanks
Delordson Kallon
http://www.instantsoftwaretraining.com