-
Syntax for SQL filter in MS Access
I want to use an SQL statement as a filter in setting a recordset. Here are 2 statements:
strJob = Me![JNum]
Set rst = dbs.OpenRecordset("SELECT * FROM [JMR] WHERE [JNum] = strJob", dbOpenDynaset)
The [JMR] table has a field [JNum]. An open form has a control which uses the [JNum} field from a different table and this latter information is to filter the [JMR] records based on its [JNum] field. I think the problem is in the use of single and double quotes in the latter part of my SQL statement. Or what?
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|