Morning All;
Is it possible to add the value 0 to a table with an append query within the criteria?
I have an append query as seen in the attachment below, and what i need to do is, if one of the fields in the query has no value or is null then make that value 0.
this does not need to happen on the financialyear field, only the fields showing QTR1, 2, 3, 4.
Is this possible?
Your help as always is appreciated.
Kind Regards
Tor Fey
Is it possible to add the value 0 to a table with an append query within the criteria?
I have an append query as seen in the attachment below, and what i need to do is, if one of the fields in the query has no value or is null then make that value 0.
this does not need to happen on the financialyear field, only the fields showing QTR1, 2, 3, 4.
Is this possible?
Your help as always is appreciated.
Kind Regards
Tor Fey