N/APosted 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?
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.