IN clause error

  • Thread starter Thread starter SL
  • Start date Start date
S

SL

I have a series of queries in a report database that pull information from
other Access DB's and display it in one summary report.

This was working fine, however I have now added an additional table,
Tbl_SaltSeason into one of the databases that the report database uses and I
keep getting error messages when I try to use the query below.

SELECT Qry_SaltSeason.Depot_Name
FROM Qry_SaltSeason IN 'S:\WMDB\Div1WmApp.mdb';

The first error message displayed is "The Microsoft Jet database engine
cannot find the input table or query <name>. Make sure it exists and that its
name is spelled correctly."
Then when I click OK to this, the following is displayed
"Data type mismatch in criteria expression. (Error 3464)"

The same query works fine in Div1WmApp.mdb, so I know its not the query,and
when I go into design view in the report database, all fields of the table
are displayed so Access is able to view the table, it just won't return the
results of the query.

Other queries work fine using IN and can display info from the database.

Does anyone have any ideas?

Thanks

Sonya
 
I have not seen IN used like that but there is a lot that I do not know of
Access.
Why not link the table from the othe database?
 
Back
Top