sam1fletcher
Registered User.
- Local time
- Today, 06:28
- Joined
- Jan 28, 2013
- Messages
- 40
Hi All
having a big problem creating a pivot table and chart. i made a pivotTable from a query which simple lists the sent and paid dates of invoices. when i first creat the table i use the "sentDate by month" range which access automatically gives you to create a range of dates for the x axis for my graph i then drag and drop both paid and sent values into the data section and get the count for both.. Great so far the table looks exactly how i want it so i save..... when i the open the query again and select PivotTable view i get an error msg saying it cannot get the values from the sentDate value. this is the same for the pivot chart. and i have no idea what is wrong as i originally got them both looking exactly how i wanted them to....
Sam
having a big problem creating a pivot table and chart. i made a pivotTable from a query which simple lists the sent and paid dates of invoices. when i first creat the table i use the "sentDate by month" range which access automatically gives you to create a range of dates for the x axis for my graph i then drag and drop both paid and sent values into the data section and get the count for both.. Great so far the table looks exactly how i want it so i save..... when i the open the query again and select PivotTable view i get an error msg saying it cannot get the values from the sentDate value. this is the same for the pivot chart. and i have no idea what is wrong as i originally got them both looking exactly how i wanted them to....
Sam