format question....help!
From: Miranda (mirandapbourke_at_hotmail.com)
Date: 02/12/04
- Next message: Michael Lam: "Re: Suggestion about query"
- Previous message: Michael Lam: "Suggestion about query"
- Next in thread: Allen Browne: "Re: format question....help!"
- Reply: Allen Browne: "Re: format question....help!"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 12 Feb 2004 19:35:33 +1100
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
- Next message: Michael Lam: "Re: Suggestion about query"
- Previous message: Michael Lam: "Suggestion about query"
- Next in thread: Allen Browne: "Re: format question....help!"
- Reply: Allen Browne: "Re: format question....help!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|