HOW NOT to send 2 envelopes to the same place

[W.Dnx.W]

Hey everyone,

I'm playing with my DB a bit and I need help in determing which way to go. When I print out labels for Envelopes or directly on envelopes, sometimes I have people living on the same address (a family), so I would like to save some on printing and actually sending several envelopes to the same address.
Now, I was thinking of doing this through the code in VBA but now I'm thinking if there is maybe more simple and faster way in building a qry.

All the data for the labels and envelops comes to a temp table from where I'm printing out reports...so what I'm not sure, is there a way to make a querry which would go through my temp table sorted by address, pick address1 then address2, if they are the same, check if lastname1 and lastname2 ise the same and then name1=name1 & Name2, delete record2 and go on...

tnx a lot

 

[FoFa]

Sounds like you can use a group by query to do what yiou want.

 

[W.Dnx.W]

How does that work...my qry skills don't go beyond qry wizard ;-))