format question....help!

  • Thread starter Thread starter Miranda
  • Start date Start date
M

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
 
Did you see the answers we gave you to your earlier post about how to get a
record for each date?
 
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
 
Yes, a report with 4 subreports would be the simplest way to display 4
unrelated sets of information.
 
Back
Top