D
DSmith
I have a list of names and each name has a license number. Sometimes a name
might have two license numbers and a second record is made. How can I get
both license numbers into one record so that they will both print on one
report when I merge the records to Word? The fields in my License table are:
LicType TNLicType Number
ARRT 000000
TN MX 0000
These are basically the 2 types of licenses I usually get. I've tried a
crosstab but there's two many combinations since I could have 50 states. It
seems there should be a simple solution--I just haven't been able to find
it. I know I could bring the form into Access but it's a certificate and
Access isn't too design friendly(graphics etc). Help would be greatly
appreciated.
might have two license numbers and a second record is made. How can I get
both license numbers into one record so that they will both print on one
report when I merge the records to Word? The fields in my License table are:
LicType TNLicType Number
ARRT 000000
TN MX 0000
These are basically the 2 types of licenses I usually get. I've tried a
crosstab but there's two many combinations since I could have 50 states. It
seems there should be a simple solution--I just haven't been able to find
it. I know I could bring the form into Access but it's a certificate and
Access isn't too design friendly(graphics etc). Help would be greatly
appreciated.