Return zeros in a make-table query instead of blanks.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to return zeros in the make-table query instead of blanks?

Any point in the right direction would be greatly appreciated.

Thanks
Zack
 
Thanks Paul. That was helpful. Also, is there a function that returns zeros
instead of negative values?

Paul Overway said:
You need to pass the source data to Nz function, i.e.,

Nz([SomeField])

--
Paul Overway
Logico Solutions
http://www.logico-solutions.com


The parawon said:
Is there a way to return zeros in the make-table query instead of blanks?

Any point in the right direction would be greatly appreciated.

Thanks
Zack
Click to expand...
Click to expand...
 
You'd have to use IIF function, i.e.,

Iif([SomeField]<0,0,[SomeField])

--
Paul Overway
Logico Solutions
http://www.logico-solutions.com


The parawon said:
Thanks Paul. That was helpful. Also, is there a function that returns
zeros
instead of negative values?

Paul Overway said:
You need to pass the source data to Nz function, i.e.,

Nz([SomeField])

--
Paul Overway
Logico Solutions
http://www.logico-solutions.com


The parawon said:
Is there a way to return zeros in the make-table query instead of
blanks?

Any point in the right direction would be greatly appreciated.

Thanks
Zack
Click to expand...
Click to expand...
Click to expand...
 
Hmmm... looks as if Paul and I are answering the same question from the same
poster in different newsgroups.

The parawon -- please do not multipost (post the same message independently
to different newsgroups). If you believe that a post should go to different
newsgroups, then use "cross-posting", meaning put more than one newsgroup in
the "Newsgroups" line of your post (separate them by a semicolon).
Otherwise, people duplicate and triplicate time answering the exact same
question.

--

Ken Snell
<MS ACCESS MVP>

Paul Overway said:
You need to pass the source data to Nz function, i.e.,

Nz([SomeField])

--
Paul Overway
Logico Solutions
http://www.logico-solutions.com


The parawon said:
Is there a way to return zeros in the make-table query instead of blanks?

Any point in the right direction would be greatly appreciated.

Thanks
Zack
Click to expand...
Click to expand...
 
O.k, I'll do that. Thanks Ken and Paul.

Ken Snell said:
Hmmm... looks as if Paul and I are answering the same question from the same
poster in different newsgroups.

The parawon -- please do not multipost (post the same message independently
to different newsgroups). If you believe that a post should go to different
newsgroups, then use "cross-posting", meaning put more than one newsgroup in
the "Newsgroups" line of your post (separate them by a semicolon).
Otherwise, people duplicate and triplicate time answering the exact same
question.

--

Ken Snell
<MS ACCESS MVP>

Paul Overway said:
You need to pass the source data to Nz function, i.e.,

Nz([SomeField])

--
Paul Overway
Logico Solutions
http://www.logico-solutions.com


The parawon said:
Is there a way to return zeros in the make-table query instead of blanks?

Any point in the right direction would be greatly appreciated.

Thanks
Zack
Click to expand...
Click to expand...
Click to expand...
 
Back
Top