query two field using or

[survivo01]

I have two fields Monday and Wednesday


If I query using yes for the Monday field it gives me the classes enrolled on Monday. Now if I query for Wednesday using Yes I end up with Mondays and Wednesday that both have yes. However I want to see the records where Monday might have a yes and wednesday will have a no or Monday with have a no and Wednesday will have a yes.

[pbaldy]

In design view, put the criteria on different lines. In SQL that creates an "OR" instead of "AND".

[June7]

It is difficult to filter records with criteria based on dynamic combinations of multiple Yes/No fields. Because each record is either true or false for each field, using the criteria you describe ((Monday = Yes And Wednesday = No) OR (Monday=No And Wednesday=Yes)) will always return all records. Triple state (Yes/No/Null) might help but I have never used that. I avoid Yes/No fields whenever possible.

Unless this is what you really meant: Monday=Yes Or Wednesday=Yes. That will exclude all records where both fields are No.

Multiple similar Yes/No fields often indicates a non-normalized data structure. A better design might be one text field with 3 options (M, W, B)

[survivo01]

I tried that but it gave me duplicat records. One for Monday and one for tuesday.

[June7]

Tuesday? When did Tuesday come into this? Why would there be 'duplicate' records? This data structure does not seem normalized and because of that will be very problematic. Provide sample of source data and expected output. If you want to provide db for analysis, follow instructions at bottom of my post.