table queries

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Table queries

Table queries

resolvedResolved · Low Priority · Version 2007

Kelly has attended:
Access Intermediate course

Table queries

How can i make a table query?

RE: table queries

Hi Kelly

Thank you for your question.

First create your query in the normal way, selecting required fields and inserting relevant parameters.

Then click on the "make table" button on the design ribbon. You will then be prompted to supply a name for your table.

Enter the name, click OK and run the query. You will then be cautioned that ou are about to create a table. Click OK and the table will be created

Regards

Stephen


 

Access tip:

Creating Parameter wildcard queries

To creat a parameter query that also uses a wildcard, in the query design type in like []+*.

View all Access hints and tips


Server loaded in 0.11 secs.