Counting Unique UID

[q582gmzhi]

Hi,

I have been trying for the last couple of week or so to get a query working.

Basically the query is used to show Hours worked by Post Code. Everything works fine and the query returns 'Hours Worked By Postcode' and Number of Records that the data was created from. (See Report in Attached DB)

However I have now been asked also to show the number of unique Members who by PCode make up the records.

So the report would look like:
By Post Code (See Report)
Number Of Members - Number Of Records - TotalTime

I am having problems returning the number of Unique Members who make up the data, in the query you will see Test and Test1 where I have tried to implement a unique count with no success.

Any help would be appreciated.

Thanks

Daz......

 

[q582gmzhi]

Pat,

Thanks for the reply.

What type of command would you use in the report to lookup and count the unique UID's?

DLookup etc?

Thanks

Daz......

 

[q582gmzhi]

Thanks

I have now sorted out the problem.

Daz....