Search results

For reference, the tbl001_ClientContactStatus.SecondaryMarketSup field is set to a Yes/No data type. "Yes and No values and fields that contain only one of two values (Yes/No, True/False, or On/Off)." Hence we I would have thought that the constant 'True' could have been picked up in SQL query.

Thanks. I spotted that earlier and have tried it with a space after the 47. That doesn't work either. When I say ' doesn't work' a "select table" windows open, which I presume means the SQL statement isn't valid (http://support.microsoft.com/kb/289830). Here is the modified SQL statement...

Hi there. I'm probably missing something really obvious, but I can't seem to get this query to work. I'm building a VBA module in Word that pulls data from an Access database in order to automate a mail merge (the email addresses to be used are driven by the query). The code works fine...