P
p-rat
I don't know if this might be a very silly question/post or not. I
have a data entry form that clerks enter in Truck Driving information.
Date, TicketNumber, Yard, TruckNumber, Driver, TicketHours, etc.
There might be 8 tickets that a Driver might complete in one shift or
one date. I have a request from an end-user to create a form that
autofills all the Driver information for a certain date. The end-user
will enter into this form the 'TotalDriverPaidHours' and then there
will be a calculation that adds up TicketHours from the main data
entry form then subtracts this total from the value just entered on
the newly created form to calculate any 'down time' or shop time.
I have a form created that I use as basically a report input parameter
that asks the user for certain information. This then brings back a
query that is correct. My main issue is I don't understand how to make
this query that is brought back (might be 1-10 rows or records
typically) look like a time sheet type form and not just a datasheet
type looking form. I need to be able to again put in a text box for
the total hours and then also return the calculation mentioned above.
I hope this isn't wasting anybody's time. I've looked and searched and
haven't found anything. Please help. I am stumped. Thanks.
have a data entry form that clerks enter in Truck Driving information.
Date, TicketNumber, Yard, TruckNumber, Driver, TicketHours, etc.
There might be 8 tickets that a Driver might complete in one shift or
one date. I have a request from an end-user to create a form that
autofills all the Driver information for a certain date. The end-user
will enter into this form the 'TotalDriverPaidHours' and then there
will be a calculation that adds up TicketHours from the main data
entry form then subtracts this total from the value just entered on
the newly created form to calculate any 'down time' or shop time.
I have a form created that I use as basically a report input parameter
that asks the user for certain information. This then brings back a
query that is correct. My main issue is I don't understand how to make
this query that is brought back (might be 1-10 rows or records
typically) look like a time sheet type form and not just a datasheet
type looking form. I need to be able to again put in a text box for
the total hours and then also return the calculation mentioned above.
I hope this isn't wasting anybody's time. I've looked and searched and
haven't found anything. Please help. I am stumped. Thanks.