Querying in Excel

[dmfitz82]

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!!

[Ron Coderre]

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


"dmfitz82" wrote:

> 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!!