Reports

C

cory

Hi,
I am looking for info on reports in MS Access. I am looking to create a
report where the report is based on the relationships in the database.

For Example:
I have a project for a client. At the end of it I want to print a report
based on the following structure.

The top of the relationship is the Client, then under the client falls a
project number, then under the project number falls equipment where there
could be many pieces of equipment. Once one of those pieces of equipment
under the project number is completed for that client, I need to create a
report of all records associated with that piece of equipment, and submit it
to the client.

I have been trying to conquer this task but for some reason I am unable to
accomplish it. I have a book on Access but it does not explain very well.

Any comments, suggestions, direction would be appreciated.

Thanks
 
L

Larry Linson

You can join related tables in a Query and base the Report on the Query. If
there will be multiple records per piece of equipment, you might look at a
subreport to show those.

I'm assuming that you have a Client table, a Project table, an Equipment
Table, and one other that has multiple records about each piece of
equipment. You didn't _exactly_ say that... clarify if I misunderstood, or
if you want to purse details.

Larry Linson
Microsoft Access MVP
 
C

cory

Yes you are pretty much right on the money with your assumptions.
There are tables for every component of the equipment though. This is the
question I have. After creating a query do I have to create a form for
every component as well, or will a subform suffice?

Thx
 
M

Marco Simone

I will try to reply, but I am far from advanced user.
I had also problem with making report.
First, I hope your database is properly designed (normalised). I assume that
you have tables like Larry said.
You can make query or queries and make report built on queries.
After creating a query do I have to create a form for
every component as well, or will a subform suffice?
Click to expand...
If you need to make report why would you create form? Form is usually for
entering data in tables.

I hope this will help.
 
T

taccea

Create a Query that links all your tables, view to make sure they link
right.
Put the equimpment items in the DETAIL band of the report.
Set a filter on the Query when you want to print the report that filters out
by project number.

Taccea
 
D

Don Leverton

Hi,

This is an exerpt from the daily FAQ post:

12) Don't set your computer to post from the future
a) Posting a message with the time/date set to the future causes
your message to remain at the top of the queue in most peoples
newsreader. Therefore, it has become a common strategy to
attract more attention.
b) Such posts are generally ignored, and may subject you to
criticism by the people in the newsgroup.
c) You have now been warned against doing this! Post that way at
your own peril.
 
Top