How Do I Make A Blank Field In A Report Show A Value of " 0 " So That Report Calculates?

[orange]

Here is a sample of where NZ goes and why.



I created a table with the following design(see graphic

There is NO DATA in the Table

I then created a query in the SQL View of the query wizard. Since there is no data in the table, there is really nothing to Sum. So in my query, I Sum(fld1) and put a label (SumResult) on the calculation; also I use the NZ function on Sum(fld1), to display a 0 if there is no value. This is Nz(Sum(fld1),0) and I have added a label(ShowMeAZero) on this calculation.

SELECT Sum([fld1]) AS SumResult, Nz(Sum(fld1),0) AS ShowMeAZero
FROM tblStampman;

The result of the query is

SumResult
ShowMeAZero



0

Good luck with your project.

Post posting: I see you responded - or gave up - while I was creating a sample to show you where NZ goes in a query and what the result of NZ is. This is a basic query. It doesn't get much easier than this.
I suggest you watch a few youtube videos, or do some tutorials at RogersAccessLibrary

Approach this whole thing as a learning opportunity - not something to be feared.

Again, sincere good luck with your project.

[June7]

NOTE: Threads merged.

StampMan, if you want a record to show in report for an entity even if that entity has no data, that gets complicated.

Say you have a table of Departments and a table for Expenses and you want to show the total expenses for each department for the month of July. If department A has no expenses in July then they won't show on the report. Forcing Department A to show a record for July in the report even if they don't have data requires more complex query structure.

Is this what you want?

[StampMan]

Thank you all for your efforts on this. I REALLY do appreciate it.

I just went with creating a false record with values of zero in it to solve the issue. Sooner or later that table will need a record added legitimately and therefore I will just overwrite the false one and things are all honky-dorey lol.

Thanks so much for all of your attention. :-)