SQL and MS-Access

[Sriram]

Hi,

I am kinda rookie in MS Access area hence this mail. I
have the following query executing fine in the SQL 2000. I
want the same to run on MS Access too. How do I achieve
that:

SELECT COLUMN1, SUM(COLUMN2) AS COLUMN2,
(SUM(COLUMN2)- SUM(COLUMN3)) AS COLUMN3
FROM TABLE1 A, TABLE2 B
WHERE B.COLUMN3 = 'FOO'
GROUP BY A.COLUMN1 ORDER BY A.COLUMN1 DESC

I want the the same query to run on both SQL as well as on
Access.

Thanks

 

[Tom Ellison]

Dear Sriram:

I don't see any apparent reason this would not run on Access, assuming
the tables are linked under the same names. I assume you may be
getting some error when you try it. Please quote the error here.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts