Reports

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

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" <noone@here.com> wrote in message
news:w5HNb.21360$De.6034@edtnps84...[color=blue]
> 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[/color]
it[color=blue]
> 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
>
>[/color]

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


"Larry Linson" <bouncer@localhost.not> wrote in message
news:C9LNb.19507$4P6.4913@nwrddc01.gnilink.net...[color=blue]
> You can join related tables in a Query and base the Report on the Query.[/color]
If[color=blue]
> 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" <noone@here.com> wrote in message
> news:w5HNb.21360$De.6034@edtnps84...[color=green]
> > 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[/color][/color]
report[color=blue][color=green]
> > 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[/color][/color]
there[color=blue][color=green]
> > could be many pieces of equipment. Once one of those pieces of[/color][/color]
equipment[color=blue][color=green]
> > under the project number is completed for that client, I need to create[/color][/color]
a[color=blue][color=green]
> > report of all records associated with that piece of equipment, and[/color][/color]
submit[color=blue]
> it[color=green]
> > to the client.
> >
> > I have been trying to conquer this task but for some reason I am unable[/color][/color]
to[color=blue][color=green]
> > accomplish it. I have a book on Access but it does not explain very[/color][/color]
well.[color=blue][color=green]
> >
> > Any comments, suggestions, direction would be appreciated.
> >
> > Thanks
> >
> >[/color]
>
>[/color]

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.
[color=blue]
> After creating a query do I have to create a form for
> every component as well, or will a subform suffice?[/color]
If you need to make report why would you create form? Form is usually for
entering data in tables.

I hope this will help.

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" <www.lirnor33@allail.co.il> wrote in message
news:#43mvS4BEHA.2804@tk2msftngp13.phx.gbl...[color=blue]
>
> "cory" <noone@here.com> ëúá áäåãòä:w5HNb.21360$De.6034@edtnps84...[color=green]
> > 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[/color][/color]
report[color=blue][color=green]
> > 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[/color][/color]
there[color=blue][color=green]
> > could be many pieces of equipment. Once one of those pieces of[/color][/color]
equipment[color=blue][color=green]
> > under the project number is completed for that client, I need to create[/color][/color]
a[color=blue][color=green]
> > report of all records associated with that piece of equipment, and[/color][/color]
submit[color=blue]
> it[color=green]
> > to the client.
> >
> > I have been trying to conquer this task but for some reason I am unable[/color][/color]
to[color=blue][color=green]
> > accomplish it. I have a book on Access but it does not explain very[/color][/color]
well.[color=blue][color=green]
> >
> > Any comments, suggestions, direction would be appreciated.
> >
> > Thanks
> >
> >[/color]
>
>[/color]

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.

"KHRI" <www.lirnor33@allail.co.il> wrote in message
news:#43mvS4BEHA.2804@tk2msftngp13.phx.gbl...[color=blue]
>
> "cory" <noone@here.com> ëúá áäåãòä:w5HNb.21360$De.6034@edtnps84...[color=green]
> > 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[/color][/color]
report[color=blue][color=green]
> > 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[/color][/color]
there[color=blue][color=green]
> > could be many pieces of equipment. Once one of those pieces of[/color][/color]
equipment[color=blue][color=green]
> > under the project number is completed for that client, I need to create[/color][/color]
a[color=blue][color=green]
> > report of all records associated with that piece of equipment, and[/color][/color]
submit[color=blue]
> it[color=green]
> > to the client.
> >
> > I have been trying to conquer this task but for some reason I am unable[/color][/color]
to[color=blue][color=green]
> > accomplish it. I have a book on Access but it does not explain very[/color][/color]
well.[color=blue][color=green]
> >
> > Any comments, suggestions, direction would be appreciated.
> >
> > Thanks
> >
> >[/color]
>
>[/color]