SQL from table or query?

[EddyLLC]

Is it more advantagous to use SQL from a table to supply data to a control
on a form as in the sql statement below:
SELECT DISTINCT flkp1.Field1 FROM flkp1;

Or sql from a query as below:
SELECT DISTINCT qry1.Field FROM qry1;

Is one faster the other? Any other reasons to use one over the other?

 

[jebry]

Hi!

I honestly can't think of a single reason why you would want to base a form on a query that only pulled the information from a single table. IMO the recordsource of a form should be as simple as possible.

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst