Select From query

**Middlemarch** · 07-04-2024, 08:07 PM

Can you use FROM in a query to get data from another database?
I can't find an Access example.

**Micron** · 07-04-2024, 08:20 PM

SELECT blah blah blah FROM TableInOtherDatabase IN 'C:\someFolder\myOtherdatabase.accdb' WHERE ...
Why not just link the other table? With your approach, I don't think you will be able to use any domain functions in such a query, such as DSum, DAvg, etc.

**Middlemarch** · 07-04-2024, 10:00 PM

Thanks Micron. I'll keep that in mind. Mainly want to try a different approach.

Select From query

Thread Tools

Select From query

Similar Threads

Select/Union query wants a field entered, but the Select/Union queries that make it up don't

MS Access select query inside another select query for selecting another value from the same table

Run select query from VBA code where criteria comes from a multi select ListBox

Use of select Top in tandem with another select query issue

Select query to gather results of other select queries

Posting Permissions