simple question..

[action]

I have a query where the same address for different people appear, how do I set the criteria so that only 1 result appears. It does not matter which person it is addressed to. I have tried first & Last but it doesnot work.

Cheers

 

[louchey]

That should work I think ??
Do you want to zip and post your DB and I'll have a look??

Louchey

 

[pbaldy]

How about

SELECT DISTINCT Address
FROM TableName