I have a query that supplies info to a chart on an input form :
everything works fine however my boss wanted the dataset on the form below
the graph (the chart dataset is awful its all squidged up) so I dropped the
query onto the form and it added a subform based on the query however it
doesnt show the dataset everything is blank. I am not sure what I did wrong
I would like to see it exactly as if I had run the query manually ie
datasheet view but on the form. it does take a parameter from the form
itself ie FrmBookingCurveInput!TxtPrior
regards in advance
the dataset is below just to prove it works on its own.
SELECT Pro.[Week Commencing], Pro.[Total Bookings], (Select Sum(Pro1.[Total
Bookings]) from Qrygetweeklycountofdosmoduleenrollments Pro1 where
Pro1.[Week Commencing]<=Pro.[Week Commencing]) AS [Running Total], Pro.[Week
Number], [Running Total]+forms!FrmBookingCurveInput!TxtPrior AS [Running sum
inc Prior]
FROM Qrygetweeklycountofdosmoduleenrollments AS Pro
ORDER BY Pro.[Week Commencing];
Qrygetweeklycountofdosmodulesptb Week Commencing Total Bookings Running
Total Week Number Running sum inc Prior
19/04/2004 1 1 21 35
20/04/2004 1 2 20 36
27/04/2004 1 3 19 37
04/05/2004 3 6 18 40
11/05/2004 1 7 17 41
18/05/2004 0 7 16 41
25/05/2004 2 9 15 43
01/06/2004 5 14 14 48
08/06/2004 1 15 13 49
15/06/2004 3 18 12 52
22/06/2004 4 22 11 56
29/06/2004 4 26 10 60
06/07/2004 7 33 9 67
13/07/2004 3 36 8 70
20/07/2004 4 40 7 74
27/07/2004 4 44 6 78
03/08/2004 9 53 5 87
10/08/2004 4 57 4 91
17/08/2004 12 69 3 103
24/08/2004 1 70 2 104
31/08/2004 5 75 1 109