Crosstab query help

G

George Schneider

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.
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simple Question on Addition 3
Creating Bank Query 0
Crosstab query error 1
Tricky Accounting query - and not sure how to build it 2
Crosstab Query 0
Problems with Crosstab Query 4
How to Union Crosstabs... 1
update crosstab 0

Top