Search results

DCrake, The reason for this is that i collate weekly stats for queues but the issue being is that this comes from 2 different sources hence i have a separate table for each but these figures are for the same week hence the reason for wanting them under 1 heading. Thanks for your help.

Hi, I have 3 tables, one that shows all queue names and 2 other tables with results from different sources. What i would like to do is to create a query that will get all the queue names and the matching results from the 2 tables but show this under 1 column. At present the link between the...

TrevorG, thanks for your response. The source tables are all the same layout. Also in regards to using a temp table, must have forgotten to mention it, but the weekly data has to be saved in order to then replicate monthyly and yearly data. Would append queries be the same way forward? Thanks...

Hi, I have been using Access for a while now, but never really created a meaningful or a DB that can be used for work purposes. At present I have a Weekly Report that has around 1000 queues in which I have to add Weekly Volumes so i thought it might be a good idea to try and develop a database...

Sephiroth0327, the query i pasted (previous post) is based on the following query (sub query) which is a combination of 4 queries, so i dont know if this is the problem. SELECT [2 AHTVolData_QRank].[Agent EIN], [2 AHTVolData_QRank].[Agent First Name], [2 AHTVolData_QRank].[Agent Last Name], [2...

I am running alot of queries based on subqueries, but in total i am dealing with a max of 3600 rows of data. Also when i say ages, its taking atleast 45 mins for each query to run. I have attached an example of a query that i am running that is from another query that i have created but this...

I was just wondering why some queries in Access take ages to load and if their is anything i can do to quicken this. Btw the queries are being run on my local machine. If somebody could please. Thanks in advance

Thanks for that. But why can't I include a column with the figures and then have a column with the sum value? Any ideas?

Hi, I am trying to run a sum query for the following table that I have. | Agent |Prod Score | | 123 |0.036 | | 123| 0.035 | | 123 |0.05 | | 456 | 0.5 | | 456 | 0.25 | | 789 | 0.9 | | 789 | 0.18 | | 789 | 0.5 | What I would like to do is to have a totals column after Prod Score (for the...

Thats rite, I do. Using Access 2007, which has the Actions and Conditions and was wondering if there was a way to write the query within their? Access_guy49 thanks for your reply, will try that out...

Hi, I have created a query to add some data into an existing table. To automate this I have created a macro to run this query when required, however what I would like to do is to add a warning message "Are you sure you want to add new data" but i am not sure how to do that. The reason being...

Hi, I have managed to write a query that has parameters for a [Start Date] and an [End Date] which works fine. I then run another query based on the results of the first query, but whenever I ran this query, i get the parameters [Start Date] and [End Date] popping up for my 2nd query. Is it...

I have written the following query, but whenever I try and run this I get a message saying Query Too Complex. =IIF([Bott]+[Top]=0,2,0) Can any1 please help? thanks in advance.

DCrake, thanks for your explanation, i have saved the module and ran the query but get an #Error in the results...

DCrake, the fields that i am using are actually results from other queries that I have ran? So could this be the problem? Btw, thanks for your answer, i will give that a go and let you know how i get on.

JANR, Thanks but unfortunately that still gives me the same error..

Hi, I have written the following formula, but get an error saying the "Query is too complex". Test: IIf([Count Advisors]<3,0,(IIf([Q Rank]>([Count Advisors]/3*2),3,0))) Any ideas why?

DCrake, I have changed the sample example that was attached, and on that spreadsheet, I have a formula in Column D2:D7 which is the answer that I am looking for. I have picked out an actual database that I have built up, which used to be to created in Excel, this is a formula that has been built...

vbaInet, am i write in saying that the dcount would only work if you define the criteria? DCount ( expression, domain, [criteria] ) but what if the criterias change from cells? in excel you would fix the cell for it to be that criteria at all times, but if this is not fixed then the formula...

Btw, i dont think iv used the best of examples for what i am trying to find out, as i can easily write a count query in access, but my question is more related to finding out how i can get access to define a field value, i.e. [Type]=A. Hope that clears my question.