Querying in Excel

[Guest]

I am trying to run a query in excel, but the problem that I am having is that
the query is returning multiple rows of duplicate information. Ex: it's
listing invoice A 20 times, instead of only listing it 1 time. I've already
trying using the word "distinct" in the SQL statement but it doen't seem to
then be returing the proper data.

I appreciate all help!!

 

[Guest]

It sounds like you need a GROUP BY statement in your SQL.

If you have questions....post a sample of your SQL and we'll see what we can
do for you.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro