syntax error

[JT]

I am having trouble with criteria in my query. I'm trying
to use an expression but keep getting a syntax error. The
expression for the GroupID field in the Vehicle table is
as follows

"where [dbo_tb_Vehicle]![GroupID]" In (select (distinct
GroupID])from [Unit Table]!)

I'm trying to select transactions from the Vehicle table
when the GroupID is in a list of distinct GroupIDs from
the Unit Table. There will be transactions in the Vehicle
table with a GroupID that is not in the Unit Table. I do
not want those transactions.

Any help in correcting the syntax would be appreciated.
Thanks for the help....

 

[Duane Hookom]

Try:
WHERE [dbo_tb_Vehicle]![GroupID] In (SELECT GroupID FROM [Unit Table])