Auto Query Problem

[Demona]

Hi Guys

I have a module for an auto query based on a check box query system. Now if I select one or the other check boxes it will display the required information, but if I check more than one box the report comes back blank. I know why it does that ... its because with the search / query argument a 'and' is placed between my search queries. My question is how do I change the query so that the 'and' becomes an 'or'? The column that the query is searching in only contains (A,B,C,& D) inside of it. For the check boxes, I am only using the standard if...then...else code. An example of the code follows.

If [GVL Shift A] = -1 Then
        where = where & " AND [Shift ID] = " & "'A'"
    End If
            
    If [GVL Shift A] = 0 Then
        where = where & " AND [Shift ID] = " & "'A'"
    End If
             
    If [GVL Shift B] = -1 Then
        where = where & " AND  [Shift ID] = " & "'B'"
    End If
        
    If [GVL Shift B] = 0 Then
        where = where & " AND [Shift ID] = " & "'B'"
    End If

etc.

Thanks for the help

Love and Kisses

Demona

 

[dcx693]

Please do not double-post questions. It creates duplication of effort.

I will answer your questions in the original post here