If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: SQL Views?

Does Access support views? if so what is the syntax for creating one?
I want to create one query what will define and use several other querys in its own execution. Is this possible or do i have no choise but to define each query seperatly and reffer to them like normal (i.e. query.field)?

Re: SQL Views?

Originally posted by hugobean
Does Access support views? if so what is the syntax for creating one?
I want to create one query what will define and use several other querys in its own execution. Is this possible or do i have no choise but to define each query seperatly and reffer to them like normal (i.e. query.field)?

Look up querydef and or recordset. I have found querydef easier to work with, but basicly they create a set of records, eather in a query or in a tableish format with out the physical table. They come in handy for me.
Jim