I have created a Union Query that counts certain criteria from a Table. I have found that if the criteria for one of the arguments in the Union Query is zero then that doesn't show up in Datasheet view. Is it possible to still show the zero values as I need to put all the selections into a report even if they don't have any value for the particular time. I thank-you for any help in advance.
Showing zero values in a Union query
- Thread starter coach.32
- Start date
- Local time
- Today, 08:34
- Joined
- Jan 23, 2006
- Messages
- 15,498
When you say zero value, do you include Null?
Null has no value; can not be found by comparing with =.
To check for Null us the IsNull(x) or
if Len(x + "") = 0...
See this link for examples
http://allenbrowne.com/casu-12.html
Null has no value; can not be found by comparing with =.
To check for Null us the IsNull(x) or
if Len(x + "") = 0...
See this link for examples
http://allenbrowne.com/casu-12.html
