Query to Return All Records

[todd8]

I want to write a query that returns all records in a database. This query is to be used as my control source for a combo box. I had done this once before, but my system was corrupted, and I cannot remember how to write this criteria for the query.

Thanks

 

[PHV]

how to write this criteria for the query
To get all records simply don't apply any criteria.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Godofhell]

Simple type Select * from your Table when constructing the SQL statement