Results 1 to 2 of 2

Thread: SQL Views?

  1. #1
    Join Date
    Jan 2003
    Posts
    4

    Question 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)?

  2. #2
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •