technett[ at ]gmail.com wrote:
[Quoted Text] > I grabbed a mdb template for customers/workorders from MS. I am trying
> to modify the "workorder labor" form in design view to have the first
> field be a manually filled in dat, followed by start time, then finish
> time.
>
> I got the boxes to show up.
>
> The problem is that when I enter a date all the fields in that column
> are filled with the same information.
>
> I tried variations of using a mask and format.
>
> Any suggestions would be greatly appreciated.
> Nett
In order to change the DB so that you can store start time/finish time
information, you need to change the underlying table, "Workorder
Labor".
You probably don't need the billable hours field at all, since that's
probably going to be calculated.
You *do* need
FieldName - Field Type
1. WorkDate Date (in the *form* you can default it to the
current date using Date() as the default value).
2. StartTime Time (I used short time hh:nn)
3. FinishTime Time (I used short time hh:nn)
Then you have to add the two fields to your form.
BillingRate becomes something like:
=DateDiff("n",[StartTime],[FinishTime])*[BillingRate]/60
(IOW, get the number of minutes worked, multiply by the billing rate
and divide by 60, because it's an hourly rate).
Hope that helps.
Pieter
|