Search results

I have two tables where one is a master table that gives me the name of the queue, who it belongs to, and where its located. What i am looking to do is link it to another table of results e.g. WE30.10.09 that has the name of the queue, volume, and time. MASTER Queue Name Owner Location...

Hi, I am a newbie to the access so please bear with me. I have a table that consists of 3 columns Name, Time, Volume. For example: Name | Time | Volume Humpty | 346 | 1 Dumpy | 644 | 262 What I would like to find out is that is it possible to add an extra column that will multiply the...

Thanks David, I will try and let you know how i get on.

David, Thats correct quite similar to when you viewing data in Excel where an AutoFilter would allow you to analyse the data that you have and pick what queues you would like to see. Thanks for your help.

Thanks for your reply. Is their anyway i can add a filter so that the user can see the report but filter the queuename on the report? For Example: Queue Name (filter) Queue 1 Queue 2

Hi, I am trying to create a report in MS Access and I have a field called QueueName. This consists of 3000 queues so i would like to add a filter so that I can filter down to any queue that I require to see on the report. I have tried to use a listbox but that doesnt work. Could somebody...

Thanks for your reply Pat. I have managed to write a third query to combine the 2 crosstabs, but the problem I am having is that I get all the count and sums within the queue column which means alot of scrolling. How could I have the values alongside each other? Thanks for your help.

Hi, Thanks for your reply. Is their any other way this query could be written in SQL?

Hi, As I have been told it is not possible to have two transform queries. What I have done is wrote two queries. One which gives me a count value and the other gives me a time value. The problem I am having is that I would like to combine these 2 but for the values to appear next to each...

I was wondering how i can convert the following query created in access to work in SQL. TRANSFORM Count(daily_effectiveness.JOBTIME) AS CountOfJOBTIME SELECT daily_effectiveness.EIN, Count(daily_effectiveness.JOBTIME) AS [Total Agent Work], Sum(daily_effectiveness.JOBTIME) AS [Total Time] FROM...

Thanks for your reply, Is their any way I can have a sum and count together?

Hi, I was wondering if somebody could help me. I have wrote the following query. TRANSFORM Count(daily_effectiveness.JOBTIME) AS CountOfJOBTIME, TRANSFORM Sum(daily_effectiveness.JOBTIME) AS SumOfJOBTIME SELECT daily_effectiveness.EIN, Count(daily_effectiveness.JOBTIME) AS [Total Agent Work]...

Thanks Rabbie, ill give that a go.

Rabbie, thanks for your reply. Currently all of the values have been entered as number of hours. So would i divide these by 24 in the query before Summing the values? Rabbie, this is the current query: SELECT Agents.LOB, Sum([ExternalShrinkage-Manager].[External Shrinkage]) AS [SumOfExternal...

Within my query I have added SUM within the Total: field, but when I dont use this it displays the separate values for each LOB (line of business) in a time format. Im not too worried about the AM and PM i just need a total i.e. 15 hours plus 13 hours should give me 28 hours. Also it is the...

I am trying to write a query to calculate time values but the values appear in number format rather than time. The following is the query that I have wrote: SELECT Agents.LOB, Sum([ExternalShrinkage-Manager].[External Shrinkage]) AS [SumOfExternal Shrinkage] FROM Agents INNER JOIN...