I have a text baox that calulates the last order date but if there have not been any orders it shows #error. I tried to use different if functions but access does not seem to like it. Here is the command i am currently using.
If there is another thread for this you can just point me there i couldn't find it.
-Kerry
Those that know, do. Those that understand, teach. -Aristotle
Code:
="Date of last order:" & Space(2) & [Orders by Customer Subform].Form!OrderDate
-Kerry
Those that know, do. Those that understand, teach. -Aristotle