Numbers from query concactinate when added in Report

  • Thread starter Thread starter Juan Schwartz
  • Start date Start date
J

Juan Schwartz

I am using the query:

TRANSFORM Count(NZ(Count([Itemized Records].Subject),0)) AS Calls
SELECT Format([Date],"yyyy-mm-dd") AS SortDate, [Itemized
Records].Subject
FROM [Itemized Records]
WHERE (((Format([Date],"mm/dd/yy"))=[Enter date(mm/dd/yy): ]))
GROUP BY Format([Date],"yyyy-mm-dd"), [Itemized Records].Subject
ORDER BY Format([Date],"yyyy-mm-dd")
PIVOT Format([Date],"hh") & ":" &
IIf(Int(Format([Date],"n"))>=30,"30","00") In
("00:00","00:30","01:00","01:30","02:00","02:30","03:00","03:30","04:00","04:30","05:00","05:30","06:00","06:30","07:00","07:30","08:00","08:30","09:00","09:30","10:00","10:30","11:00","11:30","12:00","12:30","13:00","13:30","14:00","14:30","15:00","15:30","16:00","16:30","17:00","17:30","18:00","18:30","19:00","19:30","20:00","20:30","21:00","21:30","22:00","22:30","23:00","23:30");


When I display the numbers in the report, they work fine. However, when
I use...

=[00:00]+[00:30]+[01:00]+[01:30]+[02:00]+[02:30]+[03:00]+[03:30]+[04:00]+[04:30]+[05:00]+[05:30]+[06:00]+[06:30]+[07:00]+[07:30]+[08:00]+[08:30]+[09:00]+[09:30]+[10:00]+[10:30]+[11:00]+[11:30]

In the report to total the row horizontally in the detail portion of
the query, it does not work...

In the footer, I use SUM([00:00]) and that works to add the totals
vertically.

Any help would be appreciated...
 
There is at least one reply in Reports where you asked the same question.

If you feel you need to post to more than one group (HINT: it's seldom
necessary), please have the courtesy to cross-post (send the one message to
all groups at once), rather than multi-post (send individual messages to
each group). In this way, all responses to your post will be available
together, regardless of what group the responder was in, and the rest of us
won't have to read your post multiple times. (It also uses fewer server
resources)
 
Back
Top