Minty
AWF VIP
- Local time
- Today, 14:56
- Joined
- Jul 26, 2013
- Messages
- 10,355
Evening all - I have a passthrough query that is generating a dynamic Pivot result. It has to be dynamic as the number and names of customers are fluid.
The problem is that Access thinks the values are text.
They are definitely cast as Decimal in SQL (Azure) but if I use the pass-through results as a record set in PPT or Excel to populate chart data, it don't work!
If I copy and paste the results straight from SSMS into Excel they are treated as numbers. Access is the guilty party here.
Any ideas?
The data looks like this.
The problem is that Access thinks the values are text.
They are definitely cast as Decimal in SQL (Azure) but if I use the pass-through results as a record set in PPT or Excel to populate chart data, it don't work!
If I copy and paste the results straight from SSMS into Excel they are treated as numbers. Access is the guilty party here.
Any ideas?
The data looks like this.
Report Date | Customer 1 | Customer 2 | Customer 3 | Customer 4 | Customer 5 |
30-Sep-19 | 29.99 | 20.00 | 19.99 | 20.00 | 19.95 |
07-Oct-19 | 29.99 | 20.00 | 19.99 | 20.00 | 19.95 |
14-Oct-19 | 29.99 | 20.00 | 19.99 | 20.00 | 19.95 |
21-Oct-19 | 29.99 | 20.00 | 18.99 | 20.00 | 19.95 |
28-Oct-19 | 29.99 | 20.00 | 18.99 | 20.00 | 19.95 |
04-Nov-19 | 29.99 | 20.00 | 19.99 | 20.00 | 19.95 |
11-Nov-19 | 29.99 | 20.00 | 19.99 | 20.00 | 19.95 |
18-Nov-19 | 29.99 | 20.00 | 18.99 | 20.00 | 19.95 |
25-Nov-19 | 24.99 | 20.00 | 18.99 | 20.00 | 19.95 |
02-Dec-19 | 24.99 | 19.00 | 18.99 | 20.00 | 19.95 |
09-Dec-19 | 29.99 | 19.00 | 19.99 | 20.00 | 19.95 |
16-Dec-19 | 29.99 | 20.00 | 19.99 | 20.00 | 19.95 |
23-Dec-19 | 29.99 | 20.00 | 19.99 | 20.00 | 19.95 |
30-Dec-19 | 24.99 | 20.00 | 19.99 | 20.00 | 19.95 |