Reports

[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

 

[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

 

[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

 

[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?

If you need to make report why would you create form? Form is usually for
entering data in tables.

I hope this will help.

 

[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

 

[KHRI]

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