Creating a field

[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.

 

[Michel Walsh]

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.