SQL statment

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Would like to know if I'm doing a form, where can I enter my SQL statement??

Sorry ah, Newbie with Access.
 
Open the form in design view, open the form properties, press Alt+Enter or
select view > properties from the menu bar.

Click on the top left corner of the form, now the you have the form
properties, select all in the TAB, the most top property called RecordSource.

You can either paste the SQL there or, on the Button on the right, with the
three dots, press on it, and a query type of form will be opened, select SQL
and paste your sql.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top