Count exclusive values in a Report

[stevepain]

Dear all,

I'm having problems with a count expression in a report. I have a series of items listed, with subdata against each one, in some cases this subdata is one rows, in others it is many rows.

Anyways, having listed these items and there subdata sets, I want a count of the number of items listed.

Unfortunately, a count on Equipment ID returns the total number of sub data items listed, as for each sub data item, the Equipment ID is associated. Is there a way of making the COUNT expression count exclusive values?

Thanks,

Stephen

 

[Matt Greatorex]

Without knowing the exact table structures, it's hard to be too precise, but try looking at Help on the 'GROUP BY' clause. I think that could be what you need.

Something like

SELECT Count([Equipment ID]), [Equipment ID]
FROM tablename
GROUP BY [Equipment ID];