C chad101 Registered User. Local time Today, 04:36 Joined Dec 31, 2005 Messages 56 Jun 5, 2007 #1 How do you set a blank field in a report to "N/A" or just 0? I have tried Nz([YourField],0) and iif IsNull([YourField],0,[YourField]).
How do you set a blank field in a report to "N/A" or just 0? I have tried Nz([YourField],0) and iif IsNull([YourField],0,[YourField]).
R Rich Guest Jun 5, 2007 #2 There is a difference between no data and data with nothing in it, which do you have?
C chad101 Registered User. Local time Today, 04:36 Joined Dec 31, 2005 Messages 56 Jun 6, 2007 #3 The report is based on a query with a left outer join. So some fields in the report remain blank (no data).. I would like these fields to have a "N/a" defualt value. Last edited: Jun 7, 2007
The report is based on a query with a left outer join. So some fields in the report remain blank (no data).. I would like these fields to have a "N/a" defualt value.
C chad101 Registered User. Local time Today, 04:36 Joined Dec 31, 2005 Messages 56 Jun 9, 2007 #4 anyone have an idea?
boblarson Smeghead Local time Today, 01:36 Joined Jan 12, 2001 Messages 32,059 Jun 9, 2007 #5 What's the field's datatype?
C chad101 Registered User. Local time Today, 04:36 Joined Dec 31, 2005 Messages 56 Jun 13, 2007 #6 Hello bob Sorry for the late response I have five fields, 4 are general numbers and one is a medium time.
Hello bob Sorry for the late response I have five fields, 4 are general numbers and one is a medium time.
