> i don't think access has views though?

yes it does, although you have to stretch the definition somewhat

if you save a query (yes, the sql, not the data) then access will let you
write another query against that query

note that the saved query can be a join, and have WHERE conditions

then the query against the query would look like

  select foo, bar
     from  thesavedquery
      where [something else]

quite useful

rudy
http://rudy.ca/


-
You are subscribed to the CFUGToronto CFTALK ListSRV.
This message has been posted by: "rudy" <[EMAIL PROTECTED]>
To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/
Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/
This System has been donated by Infopreneur, Inc.
(http://www.infopreneur.net)

Reply via email to