Below is a query in Access database that works in access. It takes all the fields inputs and display at the bottom the total. I then tried to run asp runner and the page doesnt even display the rest of the databases and pages run fine. Is there something I am missing in trying to get a field say home visitsbeing added to by staff then giving a total at the end of the month. ? So effectively the rest of the tables feeding this work on the web for the staff but I can not get this to display. However if I download off the web the DB I can see the query working correctly and showing the figures I require?
Thanks in advance for any help on this. Regards Martyn
SELECT Preston.[Staff Name], Preston.Activity, Preston.[Reporting Month], Sum(Preston.[CL Home Visit]) AS [SumOfCL Home Visit], Sum(Preston.[CL Supporting SU to an Event]) AS [SumOfCL Supporting SU to an Event], Sum(Preston.[CL Active Case Load in the Month]) AS [SumOfCL Active Case Load in the Month], Sum(Preston.[CA Home Visit]) AS [SumOfCA Home Visit], Sum(Preston.[CA Sitting Service (SB)]) AS [SumOfCA Sitting Service (SB)], Sum(Preston.[CA Attending Hosp (CA)]) AS [SumOfCA Attending Hosp (CA)], Sum(Preston.[CA Attending Comm Health (CA)]) AS [SumOfCA Attending Comm Health (CA)], Sum(Preston.[CA General Support]) AS [SumOfCA General Support], Sum(Preston.[CA Active Case Load in the Month]) AS [SumOfCA Active Case Load in the Month], Sum(Preston.[FC Home Visit]) AS [SumOfFC Home Visit], Sum(Preston.[FC First Clipping]) AS [SumOfFC First Clipping], Sum(Preston.[FC Repeat Clipping]) AS [SumOfFC Repeat Clipping], Sum(Preston.[FC Finger Nail Clipping]) AS [SumOfFC Finger Nail Clipping], Sum(Preston.[FC Active Case Load in the Month]) AS [SumOfFC Active Case Load in the Month], Sum(Preston.[SS Home Visit]) AS [SumOfSS Home Visit], Sum(Preston.[SS Crisis Shop]) AS [SumOfSS Crisis Shop], Sum(Preston.[SS Assisted Shop]) AS [SumOfSS Assisted Shop], Sum(Preston.[SS Internet Shop]) AS [SumOfSS Internet Shop], Sum(Preston.[SS Food Item]) AS [SumOfSS Food Item], Sum(Preston.[SS Non Food Item]) AS [SumOfSS Non Food Item], Sum(Preston.[SS Active Case Load in the Month]) AS [SumOfSS Active Case Load in the Month], Sum(Preston.[HS Home Visit]) AS [SumOfHS Home Visit], Sum(Preston.[HS Domestic (cleaning, laundry)]) AS [SumOfHS Domestic (cleaning, laundry)], Sum(Preston.[HS Errand (script, pension)]) AS [SumOfHS Errand (script, pension)], Sum(Preston.[HS Assisted Errand]) AS [SumOfHS Assisted Errand], Sum(Preston.[HS Shopping]) AS [SumOfHS Shopping], Sum(Preston.[HS Telephone Support]) AS [SumOfHS Telephone Support], Sum(Preston.[HS Emotional Support]) AS [SumOfHS Emotional Support], Sum(Preston.[HS Other]) AS [SumOfHS Other], Sum(Preston.[HS Supporting SU to an Event]) AS [SumOfHS Supporting SU to an Event], Sum(Preston.[HS Active Case Load in the Month]) AS [SumOfHS Active Case Load in the Month], Sum(Preston.[E Home Visit]) AS [SumOfE Home Visit], Sum(Preston.[E Domestic (cleaning, laundry)]) AS [SumOfE Domestic (cleaning, laundry)], Sum(Preston.[E Errand (script, pension)]) AS [SumOfE Errand (script, pension)], Sum(Preston.[E Assisted Errand]) AS [SumOfE Assisted Errand], Sum(Preston.[E Shopping]) AS [SumOfE Shopping], Sum(Preston.[E Telephone Support]) AS [SumOfE Telephone Support], Sum(Preston.[E Emotional Support]) AS [SumOfE Emotional Support], Sum(Preston.[E Other]) AS [SumOfE Other], Sum(Preston.[E Supporting SU to an Event]) AS [SumOfE Supporting SU to an Event], Sum(Preston.[E Active Case Load in the Month]) AS [SumOfE Active Case Load in the Month], Sum(Preston.[FO Home Visit]) AS [SumOfFO Home Visit], Sum(Preston.[FO Build Relationship]) AS [SumOfFO Build Relationship], Sum(Preston.[FO Promote Confidence]) AS [SumOfFO Promote Confidence], Sum(Preston.[FO Maintain Independence]) AS [SumOfFO Maintain Independence], Sum(Preston.[FO Reduce Isolation]) AS [SumOfFO Reduce Isolation], Sum(Preston.[FO Daily Living Skills]) AS [SumOfFO Daily Living Skills], Sum(Preston.[FO Hobbies and Interests]) AS [SumOfFO Hobbies and Interests], Sum(Preston.[FO Enhance Well Being]) AS [SumOfFO Enhance Well Being], Sum(Preston.[FO Other Visit]) AS [SumOfFO Other Visit], Sum(Preston.[FO Supporting SU to an Event]) AS [SumOfFO Supporting SU to an Event], Sum(Preston.[FO Active Case Load in the Month]) AS [SumOfFO Active Case Load in the Month], Sum(Preston.[CSI Home Visit]) AS [SumOfCSI Home Visit], Sum(Preston.[CSI Signposting]) AS [SumOfCSI Signposting], Sum(Preston.[CSI Financial Support]) AS [SumOfCSI Financial Support], Sum(Preston.[CSI Emotional Support]) AS [SumOfCSI Emotional Support], Sum(Preston.[CSI General Paperwork]) AS [SumOfCSI General Paperwork], Sum(Preston.[CSI Other]) AS [SumOfCSI Other], Sum(Preston.[CSI £ Benefit Collected]) AS [SumOfCSI £ Benefit Collected]
FROM Preston
GROUP BY Preston.[Staff Name], Preston.Activity, Preston.[Reporting Month];
