syntax error

  • Thread starter Thread starter JT
  • Start date Start date
J

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....
 
Back
Top