Please Help!!!? Select * From

[Guest]

I have been given a solution to an earlier post that I understand but can't
get to work.
Is the Select * From function used in Query Criteria box or elsewhere? I'm
dying to find out!

 

[Jeff Boyce]

Ashley

SELECT * FROM YourTable;

is a SQL statement. If you created a new query in design mode, added table
"YourTable", and dragged the "*" into the grid, you could change the view to
the SQL view (of the query) and see the above statement.

Not a function... Run the statement where you'd run a query.

Regards

Jeff Boyce
<Access MVP>