SET VAR vPHinQuotes = (‘’’’ + .vEntryVar + ‘’’’ ) That’s two lots of four single quotes – I couldn’t find an old-fashioned quote on my keyboard if the mail system has messed them up.
Regards, Alastair. From: Carpet Broker, Dick Fey Sent: Tuesday, March 31, 2015 5:43 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Building Query in a form 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. ================================================
