Thread: IIF Record =
View Single Post
  #2  
Old March 3rd, 2010, 04:40 PM posted to microsoft.public.access.queries
ghetto_banjo
external usenet poster
 
Posts: 325
Default IIF Record =

there is an extra Comma in your updated expression (not sure if that
was just a typo here in the forum).

other than that, make sure you have added table Export_Data to your
query so the SQL generated can reference it. You don't need to Join
it to another table from the looks of things, but it needs to be in
the query design.