group by one field

[cmills]

I need to do labels for a mailing. i have a table but it has more than one record in the table per consumer. it is a download from a much larger database. i want to group by language but sort by lastname and only want one label per consumer even thou there is more than one record in the table. Mail merging to word, doesn't group by language and running a report doesn't give me one label per consumer, atleast as far as my novice knowledge of access will bring me. any ideas?

 

[dhookom]

Create a query that groups by so that you don't see duplicates. You can use the totals query like you would a table although it's not updateable.

Duane
Hook'D on Access
MS Access MVP

 

[cmills]

Thanks, i am very new to access. I keep forgetting it matters where you place the fields in design view.

 

[dhookom]

So are you good now or do you still need some assistance?

Duane
Hook'D on Access
MS Access MVP

 

[cmills]

i'm all set, thank you!