Sometimes you work on something so long your brain goes numb.
I want to build a query, user enters a vendor code, and the query gets
built.
Form: Enter PayCode users enters PH
Resulting query needs to read; where paycode = 'PH'
Cannot figure out how to get the query to pick up the PH with quotes.
have tried .variables, &variables, cannot get it to work.
The whole query is much more complex, but once I get the code to work
for 1 field, I am set.
Probably a 'duh' but I would welcome suggestions
Dick Fey
Carpet Broker Inc.
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
