MS Access 2003 Query Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Where would I find the best information (tutorial) on working with Queries?
I have several tables that I want to be able to print a single report from.
I have found that I need to make a query of the tables in question then pull
my report from there. So far all i am getting are blanks - nothing there
even though there is information in the tables.

Please help.

Thank you.
 
Create the query, and test that it IS returning results. Once you know the
query is sound, then focus on getting the report to work.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting
 
Hi.
Where would I find the best information (tutorial) on working with Queries?
Click to expand...

One may find the best information about queries either in a formal classroom
setting or by finding a mentor willing to spend the time with a student.
Short of that there are a few free online tutorials that are geared towards
Access, as opposed to some of the other RDBMS's out there.

Many people start out withe the query grid in Query-By-Example (QBE) and
never go any further in designing queries, but if one wants to do any serious
querying of relational data, then proficiency in the Structured Query
Language (SQL) is a must-have. Some links to get you started:

QBE:
http://www.cob.ohio-state.edu/~muhanna_1/837/MSAccess/tutorials/qbe_intr.pdf

Introduction to SQL:
http://www.functionx.com/access/Lesson16.htm

Queries and Relationships:
http://www.functionx.com/access/Lesson17.htm

Action Queries:
http://www.functionx.com/access/Lesson21.htm

Tom Wickerath's easy step-by-step tutorial on crosstab queries:
http://www.Access.QBuilt.com/html/crosstab_queries.html

Parameter queries:
http://www.cob.ohio-state.edu/~muhanna_1/837/MSAccess/tutorials/param.pdf

Creating and Running Queries
http://cisnet.baruch.cuny.edu/holowczak/classes/2200/access/accessall.html#sec_queries

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.
 
Back
Top