K KathrynM Dec 4, 2003 #1 Does anyone know if there is a limit to the number of OR criteria that can be used in the QBE gird?? TIA KathrynM
Does anyone know if there is a limit to the number of OR criteria that can be used in the QBE gird?? TIA KathrynM
A Allen Browne Dec 4, 2003 #2 Yes. Depends on your version. In Access 2003 you are limited to 100 AND/OR phrases in a WHERE clause. If you are hitting that limit, you may find the IN operator helpful, e.g.: IN ("A", "B", "C", "D")
Yes. Depends on your version. In Access 2003 you are limited to 100 AND/OR phrases in a WHERE clause. If you are hitting that limit, you may find the IN operator helpful, e.g.: IN ("A", "B", "C", "D")
