L
Larry
am trying to build a report that just shows participants with a yes in their
combo box for the purposes of a merge document. However, the merge generates
all records, even though the report in Access just shows the intended.
here is the query:
SELECT BIG04.[RSVP Yes], BIG04.Prefix, BIG04.Salutaton, BIG04.[Last Name],
BIG04.Initial, BIG04.[First Name], BIG04.Suff, BIG04.Title,
BIG04.[Company/Org Name], BIG04.Address, BIG04.[Address 2], BIG04.City,
BIG04.State, BIG04.ZIP, BIG04.Email, BIG04.Phone
FROM BIG04
WHERE (((BIG04.[RSVP Yes]) Not Like "?"))
ORDER BY BIG04.[RSVP Yes];
combo box for the purposes of a merge document. However, the merge generates
all records, even though the report in Access just shows the intended.
here is the query:
SELECT BIG04.[RSVP Yes], BIG04.Prefix, BIG04.Salutaton, BIG04.[Last Name],
BIG04.Initial, BIG04.[First Name], BIG04.Suff, BIG04.Title,
BIG04.[Company/Org Name], BIG04.Address, BIG04.[Address 2], BIG04.City,
BIG04.State, BIG04.ZIP, BIG04.Email, BIG04.Phone
FROM BIG04
WHERE (((BIG04.[RSVP Yes]) Not Like "?"))
ORDER BY BIG04.[RSVP Yes];