Query to find unique account

[turil]

Hello,
I have a data base and i need to identify how manny different accounts it contains. A account is formed by a distinct combination of Group, Div, Policy - found on differnt colums and of a text format.
for instance i could have:
Account Group Div Policy
acct1= 79213 001 ac1-254-134
acct2= 79213 001 123-dff-215
acct3= 59421 305 123-dff-215
I am a total beginner and any help with this would be much appreciated!
Thank you in advance

 

[dhookom]

Isn't this the same question as thread701-1547637? If so, this should be ignored.

Duane
Hook'D on Access
MS Access MVP

 

[turil]

Hi Duane,
Yes it should be ignored, I listed it under Access Queries and JET SQL as well, could not decide which forum is more apropriate.
Is there a way to close it?

Thanks,

Theresa

 

[dhookom]

You could Red Flag the post if you want it removed.

Duane
Hook'D on Access
MS Access MVP