Creating report & inculde null values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have created a monthly report which shows total minutes used for each customer every day. However not every customer has minutes used each day. I need to include days 1-30(31) for all customers every month. Since some customers have days with no minutes those days are not included. I am not sure how to do this. The report is grid style with cusotmers in the rows and I would like the 1-30 days in separate columns. I would appreciate any input.
Thanks!
 
Is your report's record source a crosstab or how are you getting 30 separate
columns?

--
Duane Hookom
MS Access MVP


Angelita said:
Hi,
I have created a monthly report which shows total minutes used for each
Click to expand...
customer every day. However not every customer has minutes used each day. I
need to include days 1-30(31) for all customers every month. Since some
customers have days with no minutes those days are not included. I am not
sure how to do this. The report is grid style with cusotmers in the rows and
I would like the 1-30 days in separate columns. I would appreciate any
input.
 
I have run across this in my crosstab report (Pivot).
How I got around it was to allocate each product
(customer) an unique number then sort by the unique
number.
 
I guess that is my problem. I don't know how to get the separate columns. would you suggest a crosstab?
thanks for the help
 
We don't know anything about your table structure or data so it is nearly
impossible to provide assistance other than to have you press F1 and search
on Crosstab Queries.
 
Back
Top