F
FerryMary
From what I've been reading, it's not good form (excuse that terrible pun) to
store calculated values. I'm using the value as a locally accepted means of
tracking for maintenance records. I had wonderful help in this forum under
database design but I neglected to mention that it would be helpful to have
the value return to the form. I've tried the DLookup and almost had it, but
not quite. This will be a multi-user system on a server so the calculation
would need to be specific to the recordID.
This will be a lame attempt to explain the query.
VesselID = 3 digit # identifying each vessel in fleet
yy=current year
@@@=2 digit numbers allowed for maintenance requests per year.
I thought to use a command button on form at a point when origination date
and vesselid have both entered. [since values required for calculation]
Using the command button to run (open) the query, {I'd prefer the query not
show while in form view} I'd like the calculation to appear in text box
(labled VMP #)
My lack of experience is embarrassing, but I'm really close to pulling this
thing together.
You guys/gals are the greatest.
Mary
store calculated values. I'm using the value as a locally accepted means of
tracking for maintenance records. I had wonderful help in this forum under
database design but I neglected to mention that it would be helpful to have
the value return to the form. I've tried the DLookup and almost had it, but
not quite. This will be a multi-user system on a server so the calculation
would need to be specific to the recordID.
This will be a lame attempt to explain the query.
VesselID = 3 digit # identifying each vessel in fleet
yy=current year
@@@=2 digit numbers allowed for maintenance requests per year.
I thought to use a command button on form at a point when origination date
and vesselid have both entered. [since values required for calculation]
Using the command button to run (open) the query, {I'd prefer the query not
show while in form view} I'd like the calculation to appear in text box
(labled VMP #)
My lack of experience is embarrassing, but I'm really close to pulling this
thing together.
You guys/gals are the greatest.
Mary