Creation of query based on tables using wizard

Asked By Haylie 0 points N/A Posted on - 11/09/2011

I would like to create a query based on tables with the use of a wizard. When doing this, it asks more details like record source, layout, format and fields, as to what you want. Accordingly, it creates a form based upon the answers. What should I do? 

• Status: Open
• Question Views: 768
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Content Management

Answered By Alber grower 0 points N/A #108720

Creation of query based on tables using wizard

Creating queries using wizards will really ask you what to display, it is a must because it is asking you what you want to see in your query. Now if you don't understand this query wizard, I suggest that you learn how to use the SQL, I am suggesting this because I think you are using a query wizard using Access. Look for the SQL button once you have click the create query in Design View.

Below is the basic syntax.

Select [column 1], [column 2]

From [table source]

Where [condition 1] <<< Optional Line

You can learn more by searching it in the internet. Just look for SQL tutorial from the internet so don't worry, it is pretty easy to use.

About Alber grower

Questions
0

Answers
370

Best Answers
106

• Vote Up 0 Vote Down

• Posted on - 11/10/2011
• Question Category: Content Management