A calculated field in Access returns time - But if the calculated field is blank it returns error
Posted on 2014-12-02
I think this might be an easy question for Access Experts :-)
I have a calculated field that has to return the starttime for bowling Lanes. But in the same file, I have the transactions, related to other form of sales (where there is no starting time.
If there is a starting time, below function Works great. [Placement] is a textfield containing other information as well.
If there is no starttime, I want my Query to return a blank cell.