format question....help!

[Miranda]

hi,

i'm trying to get my first ever report going. i was wondering if this is
possible.

i have a database that stores info about labour, equipment, materials and a
couple of other things. Each of these categories has the same kind of info
e.g. equip name, material name,....date Used, Number Used.

labour, equipment, materials etc are all related to a project but not to
eachother.

I want to create a report for a single project that shows all of this
information as well as monetary values.

so basically i want something that looks like this


____________________________________________________________________

PROJECT NAME

DATE: monday dd/mm/yy

Equipment

equipmentName numberUsed
truck 1
car 2
------
3
$ some calculated total
value



Labour

labourType NumberUsed
**** ***
**** ****
------
Totals


Materials
As above

Date: Tuesday dd/mm/yy

equipment


labour

materials


and so on. I have a form where a user enters the required time frame: Date -
Date. Every date between the two entered dates should be shown. and the
labour, materials etc information should be displayed based on the DateUsed
Field.

Is it possible to set a page up like this? according to date even though the
sections are not related to eacother

any help would be appreciated!

thanks in advance!!

Miranda

 

[Allen Browne]

Did you see the answers we gave you to your earlier post about how to get a
record for each date?

 

[Miranda]

Yeah, i did Thanks. But this is a different question. Maybe i didn't make
that clear.

When you are making a report, you have a header and a detail section. So you
can display a set of information for example Equipment usage. But i want to
display 4 unrelated sets of information, equipment, labour, materials,
users. Can i do this with a regular report...or do i need to use subreports?
or something more advanced than a plain old report.

thanks,
miranda

 

[Allen Browne]

Yes, a report with 4 subreports would be the simplest way to display 4
unrelated sets of information.