Pivot table in form

F

F Jones

Hello

I have a pivot table in a form. Yesterday when I created it, it put in
totals at the end. Today the totals are empty and it is labelled "no totals".
I don't know what has changed. I created the form again and it came up empty
again.
The pivot is based on the follwing query:

SELECT tblWorkingHours.txtName, tblWorkingHours.Type,
tblWorkingHours.dtmDate, tblWorkingHours.txtHoursWorked,
tblWorkingHours.numMinutesWorked, tblEmployees.txtteam
FROM tblWorkingHours LEFT JOIN tblEmployees ON tblWorkingHours.txtName =
tblEmployees.txtName
WHERE (((tblWorkingHours.Type)="In Work") AND ((tblWorkingHours.dtmDate)
Between [Forms]![frmReportMenu]![txtstartdate] And
[Forms]![frmReportMenu]![txtenddate]) AND
((tblEmployees.txtteam)=[Forms]![frmReportMenu]![cmbTeam]));

Any ideas? - feel free to point out the obvious.

thanks
 

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

Similar Threads

Pivot table 0
Dynamic Pivot Table 0
Embed OLE Excel Pivot Tables in Access Forms? Access v2003 and ff. 0
Embed OLE Excel Pivot Tables in Access Forms? Access v2003 and ff. 0
Excel 2010 Pivot Table 2
Splitting up data in a pivot table 1
Pivot Table 2
Selecting Date Range in a Pivot using VBA 0

Top