B
brent
I have a very simple query that consists of a location, an amount for a sale,
and a date in three seperate fields. When I run the query there are certain
locations that have all zero's because they didn't sell any of that
particular product in the specified time period. Is there a way for me to
tell the query in those instances that if the location name returns all
zero's, just display one instance of that location and zero?
and a date in three seperate fields. When I run the query there are certain
locations that have all zero's because they didn't sell any of that
particular product in the specified time period. Is there a way for me to
tell the query in those instances that if the location name returns all
zero's, just display one instance of that location and zero?