I
igorin
Hello,
Hopefully you can help me.
I have the following database:
(Note: date format is dd/mm/yy)
Date Bulldozer Crane Excavator
01/01/09 5.3 7.8 9.4
02/01/09 2.3 12.2 8.1
03/01/09 1.9 23 2.7
04/01/09 3.8 19.4 13.5
05/01/09 9 12.1 6.7
06/01/09 10.1 7.4 15.2
In a Form there would be text boxes for each equipment field (Bulldozer,
Crane, Excavator). And there should also be a text box for a start date and
another for an end date. Then, once the input dates (start & end date) are
given, the text boxes for each equipment field should show the sum of the
values between the search dates.
For example, if I input in the form these dates:
Start date: 02/01/09
End date: 04/01/09
Then in the text boxes for the equipment fields should appear the values for
the corresponding sum:
Bulldozer: 8 (this is the sum 2.3 + 1.9 + 3.8)
Crane: 54.6 (this is the sum 12.2 + 23 + 19.4)
Excavator: 24.3 (this is the sum 8.1 + 2.7 + 13.5)
I have two questions:
1) How should the query be done?
2) Once the query is done I would just need to make the form as usual, is
this correct?
Thanks for the help!
Hopefully you can help me.
I have the following database:
(Note: date format is dd/mm/yy)
Date Bulldozer Crane Excavator
01/01/09 5.3 7.8 9.4
02/01/09 2.3 12.2 8.1
03/01/09 1.9 23 2.7
04/01/09 3.8 19.4 13.5
05/01/09 9 12.1 6.7
06/01/09 10.1 7.4 15.2
In a Form there would be text boxes for each equipment field (Bulldozer,
Crane, Excavator). And there should also be a text box for a start date and
another for an end date. Then, once the input dates (start & end date) are
given, the text boxes for each equipment field should show the sum of the
values between the search dates.
For example, if I input in the form these dates:
Start date: 02/01/09
End date: 04/01/09
Then in the text boxes for the equipment fields should appear the values for
the corresponding sum:
Bulldozer: 8 (this is the sum 2.3 + 1.9 + 3.8)
Crane: 54.6 (this is the sum 12.2 + 23 + 19.4)
Excavator: 24.3 (this is the sum 8.1 + 2.7 + 13.5)
I have two questions:
1) How should the query be done?
2) Once the query is done I would just need to make the form as usual, is
this correct?
Thanks for the help!