Using IN syntax in a Filter

[ybg1]

Hello there!

The following code works fine

G_StrWhere = "[Group]=" & G_Group_Code & " AND " & "[EntryDate]=" & SQLDate(G_Greg_Date)

Me.Filter = G_StrWhere
Me.FilterOn = True

I would like to get 2 Groups together in the first part using the syntax " IN"
e.g. (4,6 IN G_Group_Code)
Anyone knows how to do it?

Thanks

 

[MSAccessRookie]

Hello there!

The following code works fine

G_StrWhere = "[Group]=" & G_Group_Code & " AND " & "[EntryDate]=" & SQLDate(G_Greg_Date)

Me.Filter = G_StrWhere
Me.FilterOn = True

I would like to get 2 Groups together in the first part using the syntax " IN"
e.g. (4,6 IN G_Group_Code)
Anyone knows how to do it?

Thanks

Your Syntax for using IN is backwards. It should be:

Where YourFieldValue {NOT} IN ( Value1, Value2, ..., ValueLast )