Parameter Query

[Guest]

I would like my parameter query to be able to pull all "A", "T", "O" or
"Blanks". I know how to do A, T and O but do not know how have the option to
pull Blanks only. Can you please help. Thank you.

 

[Guest]

If I undertand your question then try

Where [FieldName] In ("A", "T", "O") Or [FieldName] Is Null

 

[John Spencer]

In Sql text that would look like

Where [MyField] = [Find What?] OR ([FindWhat?] is Null and [MyField] Is
Null)

In the grid, I'm not sure how Access would set it up. I would try

Field: MyField
Criteria: [Find What?]
Criteria(2): ([FindWhat?] is Null and [MyField] Is Null)

When you save the query, Access will rearrange things. The query MAY
become to complex if you have multiple criteria.