Creating a field

  • Thread starter Thread starter Gary Nelson
  • Start date Start date
G

Gary Nelson

In Access2000 frontend, SQL server backend.

I have a form with two fields - StartTime and EndTime. Once the EndTime
has been entered, this signifies that a "plate" has been completed. I have
been asked to create a field on a seperate report which will be,
"PlatesCompleted" which will be driven from the EndTime field being filled
in.

Can you offer some assistance as to how I can do this, and where is should
be written.
 
Hi,


EndTime Is Null


return either True, either False. So, you need to negate the expression to
know if your plates are completed, or not. If you make the test in VBA,
then you use instead:

IsNull( EndTime )




Hoping it may help,
Vanderghast, Access MVP.
 
Back
Top