Label Displaying ID?

scouser

Registered User.
Local time
Today, 06:51
Joined
Nov 25, 2003
Messages
767
I have a strange one. I created qryCustomerLabels. I used the Label Wizard to construct the label report. The query runs fine, all the data is correct. However the rprtCustomerLabels displays a Numerical (ContactID) value as a Prefix to the name? But not on all? See attached jpeg.
Anybody know why?
Cheers,
Phil.
 

Attachments

  • Label Issue.JPG
    Label Issue.JPG
    23.6 KB · Views: 129
How Right You Are

Pat the penny has finally dropped!! I added tblTitle, amended the query in SQL View and all is working.
Thanks for giving me the kick I needed!!!
Regards,
Phil.
 

Users who are viewing this thread

Back
Top Bottom