Please register to participate in our discussions with 2 million other members - it's free and quick! Some forums can only be seen by registered members. After you create your account, you'll be able to customize options and access all our 15,000 new posts/day with fewer ads.
Depends on the complexity and how often you think you'll reuse the data presented by the query. You can just as easily build the query directly in the report. Clicking on the tool button for the data source will put you into the query designer it will just save it directly in the report instead of as a query.
There is also a query wizard that is worth a shot (not available from inside the report, IIRC). It does a decent job of walking you through it if you are unfamiliar with SQL and its syntax.
I took Access years ago, and throughout my IT career, never used it. I remember I got an A in the class. It's all GUI based and easy. There should be online documentation.
I thought there might be a wizard
I want to create a report but Im thinking I should set up a query first
If your going to be running reports it's best to base the report off of a query so you can narrow/expand what data you want the report to include.
Wizards are a good way to start. although you will most likey have to go into the design of the query to get it to do exactly what you want.
Please register to post and access all features of our very popular forum. It is free and quick. Over $68,000 in prizes has already been given out to active posters on our forum. Additional giveaways are planned.
Detailed information about all U.S. cities, counties, and zip codes on our site: City-data.com.