Access 2010 Query Expression
Posted on 2015-01-14
This shouldn't be a problem for me but it is. I can't get the following to select properly.
The field is called [AGE_GROUP] and may contain the characters "A" or 'Y".
The Criteria row code is:
What should happen:
- If ALPHA_PARAMETER_3 = "B" then select all records. i.e. Value "A" and "Y" records.
- If ALPHA_PARAMETER_3 = "A" then select only value "A" records.
- If ALPHA_PARAMETER_3 = "Y" then select only value "Y" records.
What should the syntax be?