Hey,
I have a query with the following code which runs great
SELECT tblstj.hhmm, Sum([tblstj]![acd_calls]+[tblstj]![abn_calls]) AS Total
FROM tblstj
GROUP BY tblstj.hhmm, tblstj.fdate, "All"
HAVING (((tblstj.fdate)=[forms]![frmDailyStats]![txtstdate]));
I want to include this code is the last line but I cannot get it to produce any data
HAVING (((tblstj.fdate)=[forms]![frmDailyStats]![txtstdate] And (tblstj.fdate)=[forms]![frmDailyStats]![txtstdate] + 1)));
Basically I want to add the total to the total of the following day.
Any Suggestions would be great.
Thanks
Chris
**Edit**
Hey pdx,
I am also having trouble tring to repost.
I used this code and now I believe its works great.
SELECT tblstj.hhmm, Sum((([tblstj]![acd_calls]+[tblstj]![abn_calls]))) AS Total
FROM tblstj
WHERE (((tblstj.fdate)=[forms]![frmDailyStats]![txtstdate] Or (tblstj.fdate)=[forms]![frmDailyStats]![txtstdate]+1))
GROUP BY tblstj.hhmm;
Thanks
Chris
I have a query with the following code which runs great
SELECT tblstj.hhmm, Sum([tblstj]![acd_calls]+[tblstj]![abn_calls]) AS Total
FROM tblstj
GROUP BY tblstj.hhmm, tblstj.fdate, "All"
HAVING (((tblstj.fdate)=[forms]![frmDailyStats]![txtstdate]));
I want to include this code is the last line but I cannot get it to produce any data
HAVING (((tblstj.fdate)=[forms]![frmDailyStats]![txtstdate] And (tblstj.fdate)=[forms]![frmDailyStats]![txtstdate] + 1)));
Basically I want to add the total to the total of the following day.
Any Suggestions would be great.
Thanks
Chris
**Edit**
Hey pdx,
I am also having trouble tring to repost.
I used this code and now I believe its works great.
SELECT tblstj.hhmm, Sum((([tblstj]![acd_calls]+[tblstj]![abn_calls]))) AS Total
FROM tblstj
WHERE (((tblstj.fdate)=[forms]![frmDailyStats]![txtstdate] Or (tblstj.fdate)=[forms]![frmDailyStats]![txtstdate]+1))
GROUP BY tblstj.hhmm;
Thanks
Chris
Last edited: