Using Access Query in SQL statement

[yogi7]

How to use Access query in SQL statement.
For example
SELECT * FROM MarketCampaignCoOpCredit
in this statement MarketCampaignCoOpCredit is Access query and not a table. If used as above, error says invalid FROM clause.

Pl help.

[Iouri]

select statement from query does work. Your statement is correct. Check the name of the query. That is the only place where you can make a mistake. Just to make sure go to Access and create a new query and check it.

Iouri Boutchkine
iouri@hotsheet.com