Hiding Records with identical Address Details

[jcbhydro]

We still have a syntax error, I'm afraid, with everything after the 4th line leading bracket highlighted.
I am inserting the code into a totally blank SQL pane with all earlier code deleted.

jcbhydro

 

[MSAccessRookie]

Forgive the confusion, but I was thinking you were using VBA Format. The SQL Pane Format would be something more like the following:

Select a.[Member ID], a.[Address 1] 
From [Mail List] as a 
Where (cStr(a.[Member ID]) + a.[Address 1]) = 
(Select cStr(Min(b.[Member ID])) + b.[Address 1] 
From [Mail List] as b 
Where b.[Address 1] = a.[Address 1] 
[COLOR=red][B]Group By Address 1[/B][/COLOR]);

The problem exists because I referred to the Address Field as Address1,a nd you refer to it as Address 1. Since you have a Special (non-alphanumeric Character) in your name (the space) the name must be closed in with Brackets like [Address 1] any time it is used. it is not enclosed in the last instance (see above). That should be what you need.

-- Rookie

NOTE: This is an example of why not using Special Characters is usually the best approach.

 

[jcbhydro]

Eureka!

I thought I had caught all of the 'Address 1' bracketss but missed the final one. Thank you so much for your persistence in achieving a successful outcome.
I have learned a great deal about coding from your patient efforts.

Kind regards

jcbhydro

 

[MSAccessRookie]

Always glad to be od service. good luck as the project moves forward