S
Scoop
I have a database that I import into Access XP, it is a tab delimited file
that is imported into an access table, let's call it DATA_TABLE. It is in
the format:
Name HairColor EyeColor ShoeSize ShirtSize
Bill Brown Brown 9.5 M
Tom Brown Blue 10.5 XL
Jack Black Brown 8.0 M
Ed Blonde Blue 11.0 XXL
. . .
What I need to do is extract certain elements from the table in order to
make mailing labels. For example, I want to make mailing lables to only
those that have an M ShirtSize without regard for any other element. In the
same fashion I would want to make mailing labels for only those with
HairColor Blonde *and* ShirtSize XL. (Please assume that one of the fields
is address, the above sample table is only for reference) In other words, I
only want to print the mailing labels targeted to a specific group contained
in the table based on certain factors and conditions being met.
i.e.
If HairColor == "Black" &
EyeColor == "Brown" then
PrintLabels;
else DontPrintLabel.
Ideally, a separate mailing label file will be created that I can then just
print in either Access, Word, .pdf, whatever. For example, I would want a
few files created based on the sort:
BlackHair.pdf
BlueEyes.pdf
ShoeSize8.pdf
BlueEyesBlackHair.pdf
By double clicking on BlackHair.pdf Acrobat would open and the mailing
labels for everyone in table DATA_TABLE with HairColor=Black would be ready
to print on the mailing lables.
I don't even know if there is some other tool/database out there that may
accomplish this easier. Thank you in advance for any assistance with this
problem.
that is imported into an access table, let's call it DATA_TABLE. It is in
the format:
Name HairColor EyeColor ShoeSize ShirtSize
Bill Brown Brown 9.5 M
Tom Brown Blue 10.5 XL
Jack Black Brown 8.0 M
Ed Blonde Blue 11.0 XXL
. . .
What I need to do is extract certain elements from the table in order to
make mailing labels. For example, I want to make mailing lables to only
those that have an M ShirtSize without regard for any other element. In the
same fashion I would want to make mailing labels for only those with
HairColor Blonde *and* ShirtSize XL. (Please assume that one of the fields
is address, the above sample table is only for reference) In other words, I
only want to print the mailing labels targeted to a specific group contained
in the table based on certain factors and conditions being met.
i.e.
If HairColor == "Black" &
EyeColor == "Brown" then
PrintLabels;
else DontPrintLabel.
Ideally, a separate mailing label file will be created that I can then just
print in either Access, Word, .pdf, whatever. For example, I would want a
few files created based on the sort:
BlackHair.pdf
BlueEyes.pdf
ShoeSize8.pdf
BlueEyesBlackHair.pdf
By double clicking on BlackHair.pdf Acrobat would open and the mailing
labels for everyone in table DATA_TABLE with HairColor=Black would be ready
to print on the mailing lables.
I don't even know if there is some other tool/database out there that may
accomplish this easier. Thank you in advance for any assistance with this
problem.