Crosstab query help

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

Guest

I have the followingTotals: Sum(dbo_DAGL!GL_DEBITS-dbo_DAGL!GL_CREDITS) calculated field in my crosstab query which works great. Which gives me the total between debits and credits by store per day. I have a slight issue if no activity the value is blank. How can I replace all the blanks with 0. THe field type of will be numeric.
 
Use the IIf(Nz( said:
-----Original Message-----
I have the followingTotals: Sum(dbo_DAGL!GL_DEBITS-
Click to expand...
dbo_DAGL!GL_CREDITS) calculated field in my crosstab query
which works great. Which gives me the total between
debits and credits by store per day. I have a slight
issue if no activity the value is blank. How can I
replace all the blanks with 0. THe field type of will be
numeric.
 
Back
Top