One Label per record

[database]

HI everyone,

I have a database in which i have one person and each person can belong to more than one place. Now i have a form on which i select the places and then run a report based on the chosen places.
Since i have one person and multiple places, i am getting multiple labels for one person. I need just one label for each person even if he belongs to more than one of the chosen places.

what do i do?
please help !

 

[KenHigg]

Place the label in the group header.(??)

 

[database]

Place the label in the group header.(??)

Hi thanks for your reply... I am not able to view all the feilds when i try to group it. Did you look at my report? It shows only the Zip code fields! how do I group it then?

Thanks
dB

 

[KenHigg]

Sorry, I can't download the example here at home. I'll look tomorrow at work if someone else can't help you...

 

[database]

Sorry, I can't download the example here at home. I'll look tomorrow at work if someone else can't help you...

Okie !

Do you know why I am not able to see all the fields for grouping? I need to group by Place but I can only choose from Zip, FAx and Dept_zip

Why is that so?

thanks
dB

 

[KenHigg]

To start with, KILL ALL THOSE MEMO fields!!! They should be text...

???

 

[database]

To start with, KILL ALL THOSE MEMO fields!!! They should be text...

???

Thanks for your help..
..but by what should I group by?...the group_name doesnt work and the name_id also doesnt work...can u help me here?

 

[KenHigg]

Does 'group_name' and 'name_id' show up in the grouping dialog box?

 

[database]

Does 'group_name' and 'name_id' show up in the grouping dialog box?

Yes it does now !!!!1....thanks for your help !!!!!... that worked great !...
I just grouped it with first name and i got the way i wanted the report !
thanks a lot!
dB