Is this possible?

[Lyncroft]

To cut a long story short - I've a dynamically created query which labels are based on. The fields are Org Name, address 1, address 2, etc and Consultation Type.

Organisations can have more than one consultation type so for example if I consult on Sheep plus Cattle that organisation will get 2 labels because of the consultation type.

How can I arrange it so that only 1 label is produced.

What I need to do is when I run the query I don't want to actually show what the consultation type is. I need to take that tick out in the query grid but obviously I still need to reference the consultation type to draw the query out. The problem is every time I run the query the tick is put back in.

 

[gblack]

Make two Queries...one for labels and one for Consulting type?

 

[Lyncroft]

Thanks for that. I'll give it a go.!!!!

Cheers

 

[gblack]

AutoNumber

OK I have a MakeTableQuery.

I want to be able to attach a field that is like the AutoNumber field, so every time I run the MakeTableQuery it will give me a new table, with a Field that Numbers each record.

How can I do this? Can it be done?