Column fills with data

  • Thread starter Thread starter technett
  • Start date Start date
T

technett

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
 
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
Click to expand...

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
 
Back
Top