reduce the number of records

[xxyy]

Dear Access experts,

Please help...

I have a table like this:

Name_City
XY___London
YX___Washington
ZZ___London
SS___Chicago
AA___London
...

How can I achive by simple setting to get all the Cities once? (I've solved this through 'group by' but there's another function in Access to do this...I can't find out...)

Thanks,
xxyy

 

[doco]

How can I achive by simple setting to get all the Cities once? (I've solved this through 'group by' but there's another function in Access to do this...I can't find out...)

What is it you want? Is it 'Achieve' or 'Archive' and what do you mean by 'get all cities at once'?

 

[xxyy]

Hi,

This is a simple select query. How can I get such a result where I can see London, Washington, etc ONLY ONCE - though there's several records with London, Washington, etc.

I'm examining a simple select query and I can't figure out how it is solved. I can't find the setting....

Please help what is the exact solution for this.

thx
xxyy

 

[xxyy]

Hi,

Sorry for my bad English & wrong terminology... I would like to get only UNIQUE values for flield "city". This is what I would like to achieve.

Thanks,
xxyy

 

[EMP]

Select distinct City from [yourTableName]

^

 

[xxyy]

Hi EMP,

Thanks for your help!!! This is exactly what I wanted!!! GBY!

xxyy