Hi
When you speak of columns/fields it sounds to me as is you are working on
the table itself. The table is just there hold data and a few other (very
few) things.
You really should not be working on it.
If you to you can create a quesry based on the table and it will look a
little like the table.
You can then add a caculated column using the formual that Stefan and
Ronaldo gave you.
Don't store the results of a calculation - for lots of reasons. You can get
the results whenever you want. You can us the result with other
calculations, you can print it in a report, etc, etc. But the main thing is
that if the base of the calculation ever changes then the result will still
be correct.
OK there are a (very) few time when you should save the results - I do this
for a currency conversion calculation as I don't save the base (the amounts
and rates) as I am only interested in the result. But for almost all
calculation you really should not store the result.
Hope this helps
--
Wayne
Manchester, England.
Charno said:
I know its a bit of an Access sin, but could the value be returned to the
table?
RonaldoOneNil said:
Set the control source property of your adhearance field to
=IIf(DateDiff("n",[DRSR Time],[Gate Time])<=60,"Hit","Miss")
:
I have a table/form which i have 2 columns/fields which time is entered.
"DRSR Time" and "Gate Time".
What i'm trying to do is return the value 'Hit' (if the difference between
the 2 times is less than 60 mins) or 'Miss' (if it is greater than 60 mins),
in a 3rd column/field called "adhearance".
Any help would be great,
Thanks