StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POAccess XP report sum calculation
text
Body
copied!<p>I am adding to a feedback database used within a call centre that handles a variety of services. </p> <p>Part of what needs to be added is a report showing the total entries for each service that a particular CSO (customer service officer) does. When information is input, it is through a form that includes 2 drop downs - one for the CSO name, and one for the Service the entry will be relevant to.</p> <p>I'd like to be able to run a report through a query where the CSO name and Service will be entered along with a date period, and the output would be a report that includes a total for each service (not just the one entered) that the CSO has received feedback for. </p> <p>I hope this makes sense, and i'm sure there is a very simple solution or formula! </p> <p>im trying to fit it into a report i already have with the following SQL code in its query: </p> <pre><code>SELECT [Query Main].[Entry No], [Query Main].[Log Entry Date], [Query Main].[Log Entry Time], [Query Main].[Daily Feedback].[CSO Name], [Query Main].[CSO Team], [Query Main].[Reference Number(s)], [Query Main].Address, [Query Main].[Feedback Comments], [Query Main].[Customer?], [Query Main].[Back Office?], [Query Main].Specify, [Query Main].[Feedback done by], [Query Main].[Feedback date], [Query Main].[CSO Comments], [Query Main].Agents.[CSO Name], [Query Main].Service, [Query Main].[Date of Error], [Query Main].[Entered By], [Query Main].[Is this CSO Feedback?] FROM [Query Main] WHERE ((([Query Main].Service)=[Enter Service Name]) AND (([Query Main].[Date of Error]) Between [Enter beginning date (dd/mm/yy)] And [Enter ending date (dd/mm/yy)]) AND (([Query Main].[Is this CSO Feedback?])="Yes" Or ([Query Main].[Is this CSO Feedback?]) Is Null));` </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload