I'm struggling a little.....

I have a list of ticket sales & each sale has a customer number.

Some customer numbers will appear more than once as they have bought multiple tickets.

I'm using the GUI report generator in a Pivot Tableto display the customer numbers that only appear ONCE in the database or only ever purchased once.

I've tried using distinct & distinct Count = 1 to filter the records but the data is not correct.

Any help would be appreciated as this will help create lots of different reports.

Rgds

Jon