Show customer once even though many entries

[Stuart Green]

I have a table of orders placed by customers, each customer having their own code. A customer may have placed just one order with me or many orders. From this table I would like to produce a list that shows my customers code just once. This must be simple but so am I it would appear as I can't get my head around it
Many thanks

 

[rbrule]

You can do this by creating a report based on your query. Follow the wizard, and it will guide you into setting grouping levels, which will accomplish what you want to do.

 

[Ally]

Sounds like you need to use a query with Group By which will group together records containing the same information.

In the query grid enter the fields you wish to display providing they are those which will not contain differing information per customer, ie

Customer No .... Customer Name ... Customer Address
This will show the same information

Customer No ... Customer Name ... Order No
This will show differing information, therefore "splitting" each customer rather than grouping together.

Click the totals icon (like a "Greek E" sign - can't think of its real name) on the toolbar (or go to View > Totals). This will add another line to the design grid inserting Group By.

When you run your query, you should have all your customers appearing only once.

Post back if you have any probs.

 

[Rich]

If you only want the customer code to appear in a query then set the UniqueValues to yes

 

[Stuart Green]

Many thanks ally that worked a treat. I needed it as a query list rather than a report as it feeds a combo box. Thnaks fro the prompt replies folks

 

[Rich]

Why not just query the Customer table?

 

[Stuart Green]

"Why not just query the customer table".
The customer table holds up to 7,000 customers names but not all may have placed an order