Using IN Syntax in a Filter

**ybg1** · 10-31-2011, 04:26 AM

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

**hertfordkc** · 10-31-2011, 05:38 AM

Have you tried to construct the query through query design and then abstract the SQL to the filter?

**ybg1** · 10-31-2011, 01:19 PM

The answer is -

"[Group] IN(4,6)" & " AND " & "[EntryDate]=" & SQLDate(G_Greg_Date)

**boblarson** · 10-31-2011, 01:30 PM

Originally Posted by ybg1

The answer is -

"[Group] IN(4,6)" & " AND " & "[EntryDate]=" & SQLDate(G_Greg_Date)

No need for the extra ampersands and quotes. This would be fine:

"[Group] IN(4,6) AND [EntryDate]=" & SQLDate(G_Greg_Date)

Keep the extraneous stuff out of there (keep it as simple as possible).

**ybg1** · 10-31-2011, 02:49 PM

Thank you for your suggestion:
"No need for the extra ampersands and quotes"
I've Kept the extraneous stuff out of there and it works fine.

What I should remove from the following so I wouldn't have extraneous stuff ?

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

Thanks

**boblarson** · 10-31-2011, 02:53 PM

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

**ybg1** · 10-31-2011, 02:59 PM

Perfect.

Thanks alot

Using IN Syntax in a Filter

Thread Tools