select queries to display combined results

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

i have a table where there are multiples customers
listed. also, i want the results of the query to show
only one instance of a customer. i am using the group by
feature on the customer's name (which is an expression
combining first and last name). i also have a count field
on the customers name. please help!
 
-----Original Message-----
i have a table where there are multiples customers
listed. also, i want the results of the query to show
only one instance of a customer. i am using the group by
feature on the customer's name (which is an expression
combining first and last name). i also have a count field
on the customers name. please help!
.
Click to expand...

Greg,

your query must be duplicating somewhere. What I tend to
do is break it right down, ie only have the two fields
customer name and the count, and see what you get; you can
build the query back up then if need be. Is it possible
the customers may have more than one name ? eg Typos etc ?


Damien
 
i have a table where there are multiples customers
listed. also, i want the results of the query to show
only one instance of a customer. i am using the group by
feature on the customer's name (which is an expression
combining first and last name). i also have a count field
on the customers name. please help!
Click to expand...

Please post the SQL view of the query; an example of the results
you're seeing; and an example of the results you would like to see.
 
Back
Top