combining fields to filter for same addresses

[BruceFrey]

Hello
I have a political database with a separate field for street number, street name and apartment number. I've been asked to prepare a query that will only list the first member of a household. Example, the query would only show one member from a two person household if they both have the same address. I figured that I would somehow prepare a query that combined these 3 fields in a expression and then display the total row and choose FIRST. That didn't work, perhaps my syntax was off. Here's what I tried:

Expression: (Trim(StrConv([AddressStreetNumber]&" "&[AddressAptNumber]&" "[AddressStreetName],3)

Then I set the Total line to FIRST

Is it my syntax or is it that I can't join separate fields together like you can in a report ?

 

[Pat Hartman]

Select AddressStreetNumber, AddressAptNumber, AddressStreetName, First(FirstName), First(LastName)
From YourTable
Group by AddressStreetNumber, AddressAptNumber, AddressStreetName;

 

[BruceFrey]

Thank You

Thanks Pat, everything worked great!