Setting Criteria for multiple Min-Max fields and OR with similar criteria

[cft]

I am confused by the apparent limitations on search criteria for multiple fields using "between_and_". I have a table with 10 fields. Standard fields with customer information, DATE, Amount, Carrier, Zip Code,etc. I am able to query successfully when I use DATE criteria Month[Enter Month as Digit] and Year[Enter Year as yyyy], and have added for $Amount "Between [Enter Minimum Range]and[Enter Maximum Range]". The problem arises when I try to query based solely on the DATE criteria. I have added the DATE criteria seperately on the following OR line, but the query seems to demand the $Amount to be selected. I thought that OR meant "in lieu of" the full set of criteria on the first line and would allow a search based on other criteria if on another line. I want to be able to search by DATE and any or all other fields, and any other of the 5 plus one, two or more of the others. I know that there are limits to the number of OR lines, but how do they operate? Am I way off base with this one?

 

[cft]

Thank you Pat - I decided to take a different strategy that made my life a lot easier. I am using a form with command buttons to call separate queries via macros. This is "cleaner" than what I was attempting to achieve via a "do-all" query set up. Thanks for the education, however. I am learning quite a bit about what I can and cannot do, or think I cannot but can, or....etc... Thanks again!