Trouble with database query

[Mejmeyster]

Hi Everyone!

I've been desperately trying to prepare a database query from Access to Excel. The problem is, when I ask MS Query to import data from more than one table, no data is importing, only the headings. The SQL is as follows:

SELECT Expense.Rent, Expense.Utilities, Assets.Cash, 
FROM `C:\My Documents\Accounts`.Expense Expense, ‘C:\My Documents/Accounts’.Assets Assets 
WHERE TransactionID = TransactionID

Everything works fine when I import from only the Expense or Assets tables, but not from both. I only need the last line of the database, so is there some way to import just one line instead of every entry?

Thanks so much for everyone's help!

[MMcCarthy]

Don't know if this will work with Ms Query ...

 
SELECT Expense.Rent, Expense.Utilities, Assets.Cash, 
FROM `C:\My Documents\Accounts`.Expense Expense As E INNER JOIN ‘C:\My Documents/Accounts’.Assets Assets As A
ON E.TransactionID = A.TransactionID

You could try designing the query in Access and using the query as the source instead.

[NeoPa]

You might want to change the SELECT line of Mary's improved code to :

SELECT E.Rent, E.Utilities, A.Cash

Also look at the quotes used in your FROM clause. When shown in [ CODE ] tags they are not all the same (The Expense link uses incorrect quote characters).
Your final code may look like :

 
SELECT E.Rent, E.Utilities, A.Cash
FROM 'C:\My Documents\Accounts'.Expense As E
  INNER JOIN ‘C:\My Documents/Accounts’.Assets As A
  ON E.TransactionID = A.TransactionID