Numbers from query concactinate when added in Report

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...
 
D

Duane Hookom

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top