Adding Duration Fields
I am trying to add duration fields but if one is blank the total doesn't show. Any suggestions? [End Time 1] - [Start Time 1] = [Time 1 Total] [End Time 2] - [Start Time 2] = [Time 2 Total] ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp,
use the Nz() function which will treat any nulls as zeros.
The formula for the field [Time 1 Total] should be
Nz([End Time 1] - [Start Time 1])
etc for each of the three fields.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
use the Nz() function which will treat any nulls as zeros.
The formula for the field [Time 1 Total] should be
Nz([End Time 1] - [Start Time 1])
etc for each of the three fields.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- As usual you are the man!!! Thank you!
Another question
On Grid Edit I am pulling from from a field on another table "Opportunities" (Parent Table). It shows all opportunities but I only want the ones that are from a certain [Division]. I can't seem to figure out how to limit it.
Thanks as always
------------------------------
Mark Comish
------------------------------- MarkShnier__You
Sorry, but I'm not understanding the question.
Is this an embedded report o a parent record form?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Comish
------------------------------
