Hey guys, does any one knows if we can query on different databases?
like:
SELECT t1.*, t2.* FROM db1.table1 t1, db2.table2 t2 WHERE XXX
thanks a lot

I am having a problem in building this query, here's the situation:
I have 3 tables 'a' 'b' and 'c'
Now in 'a' there are two fields 'alias' and 'aid', in 'b' there are
two fields 'category' and 'bid' and in 'c' there are two fields 'aid'

I am trying to find a solution to the following.  I have a Table with
thousands of records that look like the following:
"CN=ExchangeService
I want my QUERY to extract everything to the RIGHT of the "=" sign

Some of you experts will probably snicker at this as being SO simple but
being a newbie to Access, I'm perplexed as how to approach it.
Basically, I'm trying to verify 2 inventories: one real (as in a physical
inventory) and one is what is expected to be there, we'll call it ...

I design many spreadsheets, but for some reason, this has me stumped.  I work
in the Food & Beverage Industry where we have many job classifications.  Each
job classification is allowed so many Full Time Assoicates, and so many Part
Time Associates.  We have a high turnover.  It is ...

First I'm new to Access, so be patient.
I want to write an update query that goes through a table and adds 1 percent
to an existing value.  fyi i'm updating interest, which changes on the first
of every month.

I created a table using a query.  Now whenever I run the query I get
popups/alerts informing me that I am deleting the table and another informing
me that I am added the data records to the table.  The query works fine.  But
I can do without the popups/alerts.  This database will ...

I'm using a make-table query to create a table used as data source for a
report. In order to ensure the data types are correct, I use convert
functions in the make-table query. However, the data types in the created
table weren't what they were supposed to be. For example, I only ...

my db has a single table, Table1. Table1 is as follows:
AUTHOR;TITLE;PUBLISHER
rows are not unique; i.e. I can have more than 1 row with the same author.
What would be the SQL code to generate a table2 with the following

I have a foreclosure database.  I have a foreclosure table and it had a
relationship to a bankruptcy table.  I wanted to change the relationship to
B_Judges instead of B_District field in the bankruptcy table.  I think its
causing problems in my query.  It tells me that I cannot ...

Hi all, I have just noticed that when i use the following query it is showing
all results and disregarding the date. I am 99% sure this worked in the past
and have not edited the query. The only thing that has changed is that we are
now in the year 2008. I use the following,

Trying to set up a simple query, and can't figure out why its not
working. Hope someone can help me think a little more clearly.
Trying to link two tables:
1)tblServices, with fields 'ClientID#', 'DateofSvc', 'SvcCode'

On the basis of my query i have built a totals query as follows:
SELECT Sum(qryMargin.MarginInvoice) AS SumOfMarginInvoice, qryMargin.
invoicedate
FROM qryMargin

I have a query that pulls 2 fields from a table.  One field (ReportName) is
selected from a form combo box.  The second field (ReportLocation) in the
query is the full path of the ReportName selected.  I want to open the
workbook using the ReportLocation, when the ReportName in the ...

Hi, I've been searching over the forums for the past hour and I cant seem to
find what may help solve my problem, hopefully its not redundant:
Goal:
In a Query, have field 1, and its chosen value from its drop down list,