Adding a zero value to a report where there is no data returned in the query

  • Thread starter Thread starter Steve Wright
  • Start date Start date
S

Steve Wright

I have a report that returns blanks when there is not data for the reported
field.
The report data comes from a crostab query.
I want to replace the blank with a zero so that I can do some calculations.
Any one out there know how to do this??

TIA
Steve
 
Steve,

In the query field, use the Nz function:
MyNewFieldName: Nz([MyFieldName], 0)

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Graham,

I can't seem to get this to work,

I think that the problem has something with trying to report non existant
data.

So if the data does not exist then I want a zero value substituted for the
blank

Steve
Graham R Seach said:
Steve,

In the query field, use the Nz function:
MyNewFieldName: Nz([MyFieldName], 0)

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Steve Wright said:
I have a report that returns blanks when there is not data for the reported
field.
The report data comes from a crostab query.
I want to replace the blank with a zero so that I can do some calculations.
Any one out there know how to do this??

TIA
Steve
Click to expand...
Click to expand...
 
Steve,

Show me the query.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Steve Wright said:
Graham,

I can't seem to get this to work,

I think that the problem has something with trying to report non existant
data.

So if the data does not exist then I want a zero value substituted for the
blank

Steve
Graham R Seach said:
Steve,

In the query field, use the Nz function:
MyNewFieldName: Nz([MyFieldName], 0)

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Steve Wright said:
I have a report that returns blanks when there is not data for the reported
field.
The report data comes from a crostab query.
I want to replace the blank with a zero so that I can do some calculations.
Any one out there know how to do this??

TIA
Steve
Click to expand...
Click to expand...
Click to expand...
 
Sorted thanks, I was doing somthing stupid!!

Ta
Steve
Graham R Seach said:
Steve,

Show me the query.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Steve Wright said:
Graham,

I can't seem to get this to work,

I think that the problem has something with trying to report non existant
data.

So if the data does not exist then I want a zero value substituted for the
blank

Steve
Graham R Seach said:
Steve,

In the query field, use the Nz function:
MyNewFieldName: Nz([MyFieldName], 0)

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

I have a report that returns blanks when there is not data for the
reported
field.
The report data comes from a crostab query.
I want to replace the blank with a zero so that I can do some
calculations.
Any one out there know how to do this??

TIA
Steve
Click to expand...
Click to expand...
Click to expand...
 
Back
Top