var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Advantage of Query on Query?
The following query is the row source for a combo box. The query "Vendors (query)" is a query on the table "Vendors". What is the advantage of the query below over a query directly on the table?
SELECT [Vendors (Query)].VendorID, [Vendors (Query)].CompanyName, [Vendors (Query)].City, [Vendors (Query)].State
FROM [Vendors (Query)];
Depends on the query - there may be no advantage at all.
Queries on queries are just like using functions etc in other programming languages - it allows code reuse and encapsulates logic.
ur codings are working excelent.
Basically, to avoid respecifying the same things over and over.
Owner and Manager of
CypherBYTE, Microsoft Access Development Specialists.
Microsoft Access MCP.
And all around nice guy!
"Heck it's something understood by accountants ... so it can't be 'that' difficult..."
"...teach a man to code and he'll be frustrated for life! "