Report Tutorials

Hi, all;

I've used access for a while, but mainly on the data entry side. I've done
reports before, but nothing terribly complex. Now I want to make a pretty
complicated report, and I'm wondering if anyone could point me to a good
tutorial.

Here's what I have:

My client sells to organizations, which can have specialties and a product
used in that specialty. Some organizations will have departments, which can
also have specialties, and a product used in the specialty, presumably the
same as what the organization is using, but not necessarily. A contact can
be part of an organization and may or may not be part of a department. The
contact has his/her own specialties and may or may not choose to use the
product being used by the organization as a whole or the department.

Therefore, I need a report that shows me organizations. Nested inside this,
I need the specialties of the organization, with the departments parallel to
the organization specialties. Parallel to both the org specialties and the
departments, I need the contacts who are part of the organization, but not
with a given department. Inside the department, I need its specialties and
its contacts with their specialties.

I'm fairly confident I can write whatever queries I need to make this
happen, but I have no idea how to make the report structure do this. If it
were a form, I'd just put in the appropriate subforms, but for a report I'm
not sure where to begin. I'm a bit fuzzy as to how you get subreports to
run "in parallel" as it were.

Hence my request for a more advanced forms tutorial than I've been able to
find.

Thanks;

Amy

I'm not sure if the lack of response to this post means that no such
tutorials exist, or that I've asked the question on the wrong newsgroup. If
this is the wrong newsgroup, where should I have asked?

Thanks;

Amy

"Amy Blankenship" wrote in message
...
Hi, all;

I've used access for a while, but mainly on the data entry side. I've
done reports before, but nothing terribly complex. Now I want to make a
pretty complicated report, and I'm wondering if anyone could point me to a
good tutorial.

Here's what I have:

My client sells to organizations, which can have specialties and a
product used in that specialty. Some organizations will have departments,
which can also have specialties, and a product used in the specialty,
presumably the same as what the organization is using, but not
necessarily. A contact can be part of an organization and may or may not
be part of a department. The contact has his/her own specialties and may
or may not choose to use the product being used by the organization as a
whole or the department.

Therefore, I need a report that shows me organizations. Nested inside
this, I need the specialties of the organization, with the departments
parallel to the organization specialties. Parallel to both the org
specialties and the departments, I need the contacts who are part of the
organization, but not with a given department. Inside the department, I
need its specialties and its contacts with their specialties.

I'm fairly confident I can write whatever queries I need to make this
happen, but I have no idea how to make the report structure do this. If
it were a form, I'd just put in the appropriate subforms, but for a report
I'm not sure where to begin. I'm a bit fuzzy as to how you get subreports
to run "in parallel" as it were.

Hence my request for a more advanced forms tutorial than I've been able to
find.

Thanks;

Amy

If you visit http://office.microsoft.com and follow the Training links in
the upper left part of the home page, it will lead you to some online
tutorials. As I recall, they cover fundamentals, and don't really extend to
any VBA issues that developers would need.

Some of the links at http://www.mvps.org/access lead to samples and websites
that may link to some tutorials. There are additional resource links at
http://ntaccess.tripod.com, and Jeff Conrad's
http://home.bendbroadband.com/conrad...essjunkie.html site has great
links, he also lists http://www.access.qbuilt.com/html/articles.html as a
fine resource. Last, but not least, I'll list Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm -- lots of good information and links,
the best I've seen on performance and corruption-avoidance in the multiuser
environment.

I am not familiar with the paid training organizations' classes or CD sets,
except to say that for the price, they _should_ be very good.

I'm not sure any of these will get you to the tutorials you are looking for,
but there is a wealth of information accessible starting with these links.

For books, I like: Microsoft Access Step by Step, from Microsoft Press, for
beginners. Special Edition Using Microsoft Access, by Roger Jennings,
published by QUE is good, and goes deeper into VBA and developer issues.
John Viescas' Microsoft Access Inside Out by Microsoft Press is another good
source. And, the books that no Access developer should be without, the
Access Developer's Handbook for many versions of Access, by Litwin, Getz, et
al, published by Sybex (don't waste time looking for an Access 2003 edition,
as there wasn't one... I am looking forward to a new edition for the next
version of Access, as I think there will be enough changes in Access to
warrant a revision).

Larry Linson
Microsoft Access MVP


"Amy Blankenship" wrote in message
...
Hi, all;

I've used access for a while, but mainly on the data entry side. I've
done reports before, but nothing terribly complex. Now I want to make a
pretty complicated report, and I'm wondering if anyone could point me to a
good tutorial.

Here's what I have:

My client sells to organizations, which can have specialties and a
product used in that specialty. Some organizations will have departments,
which can also have specialties, and a product used in the specialty,
presumably the same as what the organization is using, but not
necessarily. A contact can be part of an organization and may or may not
be part of a department. The contact has his/her own specialties and may
or may not choose to use the product being used by the organization as a
whole or the department.

Therefore, I need a report that shows me organizations. Nested inside
this, I need the specialties of the organization, with the departments
parallel to the organization specialties. Parallel to both the org
specialties and the departments, I need the contacts who are part of the
organization, but not with a given department. Inside the department, I
need its specialties and its contacts with their specialties.

I'm fairly confident I can write whatever queries I need to make this
happen, but I have no idea how to make the report structure do this. If
it were a form, I'd just put in the appropriate subforms, but for a report
I'm not sure where to begin. I'm a bit fuzzy as to how you get subreports
to run "in parallel" as it were.

Hence my request for a more advanced forms tutorial than I've been able to
find.

Thanks;

Amy