Say you've got a report that draws some fields from a query, then spits out their values on a report. Now what if I wanted to set some sort of condition on one of the number data-type fields such that, "If is blank/zero, don't display other field."
In this report, say I want to set it up such that "If 'Hours Spent' is blank/zero, then don't display 'Project Description' (or make it blank--whatever)." And then, how would you do something like "If 'Hours Spent' is blank/zero, then don't show that particular record at all." ?
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
Since the "default " default value for a numeric field is 0, how are you getting null values? If the users are deleting the 0 change the validation rule to is not null
The first problem is solved: I simply went to the query that is the
backbone to the report, and for the "Hours Spent" field, I put a
condition in the criteria, <>0 . So that's over and done with.
But I'm still looking for ideas on the second question. That is,
regarding the other numeric field(s) needing to display "0" if the
field is null/left blank. I thought maybe changing the underlying query
to an "Update Query", and putting "Null" as the Criteria, and putting
"0" as the "Update To". But the thing is, this is already designated as
a "Totals" query, and changing it to a Update Query would restructure
it. Is re-making a new query with just this one field designated as an
Update Query and structuring it like this a good idea? Assuming I do
create a query like this, and as this report will periodically be
checked, what's a way I could automate it to run so that there's never
any nulls, but always 0's in the final report?
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
Ok, I was mistaken. I thought since I had not directly addressed this that it was not yet fixed. But it appears to be self-correcting--possibly as a result of what I did in correcting the other field--as I now cannot make a query that returns any blank numeric values at all in the report. So that's great.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
