Add zero as a value with an append query (1 Viewer)

Tor_Fey

Registered User.
Local time
Today, 11:36
Joined
Feb 8, 2013
Messages
121
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
 

Attachments

  • append query.png
    append query.png
    14.1 KB · Views: 100

Minty

AWF VIP
Local time
Today, 11:36
Joined
Jul 26, 2013
Messages
10,354
You'll need to Nz() the values in the underlying query. Then you won't see any nulls.
 

Tor_Fey

Registered User.
Local time
Today, 11:36
Joined
Feb 8, 2013
Messages
121
Hi Minty;

thanks for the reply;

My qtr field in the underlying query is as follws:

Code:
Qtr1: financialQtr([TF_Ben_Sanction_Date],1)

How do i add the NZ() to the criteria as when i try it; i get the following error:

'The expression you entered has a function containing the wrong number of arguments'

Regards
Tor Fey

You'll need to Nz() the values in the underlying query. Then you won't see any nulls.
 

isladogs

MVP / VIP
Local time
Today, 11:36
Joined
Jan 14, 2017
Messages
18,186
PMFBI

Code:
Qtr1: Nz(financialQtr([TF_Ben_Sanction_Date],1),0)
 

Tor_Fey

Registered User.
Local time
Today, 11:36
Joined
Feb 8, 2013
Messages
121
Hi Ridders;

Much appreciated; this has achieved what i needed.

Kind Regards
Tor Fey

PMFBI

Code:
Qtr1: Nz(financialQtr([TF_Ben_Sanction_Date],1),0)
 

Users who are viewing this thread

Top Bottom