U.S. CitiesCity-Data Forum Index
Go Back   City-Data Forum > General Forums > Science and Technology > Computers
 [Register]
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.
View detailed profile (Advanced) or search
site with Google Custom Search

Search Forums  (Advanced)
 
Old 05-04-2009, 07:58 PM
 
Location: Houston Texas
1,003 posts, read 2,198,918 times
Reputation: 244

Advertisements

Thanks!
Reply With Quote Quick reply to this message

 
Old 05-04-2009, 08:01 PM
 
Location: Lemon Grove, CA USA
1,055 posts, read 3,647,949 times
Reputation: 952
Depends on what you are doing but in general it is just by using access. The query design GUI is a very handy tool.
Reply With Quote Quick reply to this message
 
Old 05-04-2009, 08:06 PM
 
Location: Houston Texas
1,003 posts, read 2,198,918 times
Reputation: 244
thanks

I thought there might be a wizard
I want to create a report but Im thinking I should set up a query first
Reply With Quote Quick reply to this message
 
Old 05-04-2009, 08:09 PM
 
Location: Lemon Grove, CA USA
1,055 posts, read 3,647,949 times
Reputation: 952
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.
Reply With Quote Quick reply to this message
 
Old 05-06-2009, 01:14 AM
 
154 posts, read 120,250 times
Reputation: 52
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.
Reply With Quote Quick reply to this message
 
Old 05-06-2009, 09:39 AM
 
Location: Wisconsin
521 posts, read 813,702 times
Reputation: 174
Quote:
Originally Posted by MyssaTx View Post
thanks

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.
Reply With Quote Quick reply to this message
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.


Reply
Please update this thread with any new information or opinions. This open thread is still read by thousands of people, so we encourage all additional points of view.

Quick Reply
Message:

Over $104,000 in prizes was already given out to active posters on our forum and additional giveaways are planned!

Go Back   City-Data Forum > General Forums > Science and Technology > Computers
Follow City-Data.com founder on our Forum or

All times are GMT -6.

© 2005-2019, Advameg, Inc. · Please obey Forum Rules · Terms of Use and Privacy Policy · Bug Bounty

City-Data.com - Archive 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35 - Top