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