Hi
I'm using the label wizard to create mailing labels in Access 2002. I am extracting this information from a 'Contacts' table. All the fields are coming out correctly on the label except for the 'Region' field. This field is the only one that appears on the 'Contacts' table with look-up values linked to another 'Regions' table.
On the label this field is coming out as a number e.g 1 instead of the name of the region e.g Auckland. Does anyone know how I can fix this?
Thanks
I'm using the label wizard to create mailing labels in Access 2002. I am extracting this information from a 'Contacts' table. All the fields are coming out correctly on the label except for the 'Region' field. This field is the only one that appears on the 'Contacts' table with look-up values linked to another 'Regions' table.
On the label this field is coming out as a number e.g 1 instead of the name of the region e.g Auckland. Does anyone know how I can fix this?
Thanks
