Board index Office Access

Problem with calculations and multiple AND's in criteria

Problem with calculations and multiple AND's in criteria

Post by John Vinso » Fri, 02 Jul 2004 08:16:00


On Wed, 30 Jun 2004 13:36:01 -0700, "P CORREA"



Try

(>=[Forms]![Switchboard]![MIN SQ FT FIELD] OR
[Forms]![Switchboard]![MIN SQ FT FIELD] IS NULL)
And
(<=[Forms]![Switchboard]![MAX SQ FT FIELD] OR
[Forms]![Switchboard]![MAX SQ FT FIELD] IS NULL)

This will show all records greater than MIN if you leave MAX blank;
all records less than MAX if you leave MIN blank; all records in
between if you fill in both; and all records in the table if you leave
both blank.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://www.yqcomputer.com/
 
 
 
Top

1. multiple ifs ands & indirect or offset?

2. Multiple ifs, and ands, and are not working

Hello again.

=IF(AND(H10=3,I10=1),B22,"")*IF(AND(H10=4,I10=0),E22,"")*IF(AND(H10=4,I10=1),D22","")=IF(AND(H10=4,I10=2),F22,"")*IF(AND(H10=4,I10=0),G22,"")*IF(AND(H10=4,I10=1I22","")

Can This be done or is it a pipe dream

Thanks Allan

3. Sumproduct assistance - need multiple ANDs and ORs

4. Multiple Nested IFs, ORs, Ands

5. Multiple ANDs

6. multiple ifs & ands indirect/offset...need help desperately pl

7. Stenciling and multiple buffer "ands"

8. multiple ifs & ands indirect/offset...need help desperately please

9. if & ands and either indirect or offset - need help fast please

10. Wireless Authentication ands Ecryption Question

11. Need help sorting out ANDs and ORs in parameter query

12. how to combine and's with or's in a if statement

13. if & ands and either indirect or offset - need help fast pleas

14. IF's & AND's

15. Nesting ,Ands

All times are UTC
Board index