I have a query which is simply 1 field, but that field contains 6 columns (obviously numbered 0 - 5).
Now I want to use a where clause so that the 4th column (or rather, column 3) is equal to a particular criteria.
What is the syntax for this?
The SQL code from the standard query with NO where clause is:
However, I want to do this in VBA and open a form based on the new result.
When I use the following WHERE Clause:
it doesn't work! It gives me a message regarding an undefined function.
How do I do this?
Thanks,
Simon
Now I want to use a where clause so that the 4th column (or rather, column 3) is equal to a particular criteria.
What is the syntax for this?
The SQL code from the standard query with NO where clause is:
Code:
SELECT tblEntrantLookup.lngzEntrantID
FROM tblEntrantLookup;
When I use the following WHERE Clause:
Code:
WHERE tblEntrantLookup.lngzEntrantID.column(3) = 1
it doesn't work! It gives me a message regarding an undefined function.
How do I do this?
Thanks,
Simon