Search results

Hi, i am looking for some help in regards to writing a query based on date and time values. I currently have 2 tables with different data and the only thing that matches between the two tables is the agents_id. Within Table 1 I have a Job Start and Job Finish Date and TimeStamp and within...

Hi, i was looking for some help in regards to being able to create forms with multiple forms that will query my database and give the user the ability to create its own reports. I have attached an image of what I am looking to create and was looking for some help, whether this is tutorials or...

Hi, i am having some problems when combining data from two tables into 1 table. Both tables have a [F Unique ID] field which I have joined but the problem I have is that within both tables I have the Unique ID 000185 that appears 65 times in each table due to other fields having different...

Hi, I was wondering if their is a way to append columns to a table just like you can with rows. i am aware that a join query would work, but i need 1 table to stay static where i can each add an extra column of data that would then show a whole years worth of data. If somebody could please...

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...

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...

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

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...

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.

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?

Hi, this is just for knowledge building purposes. I was looking to find out how i can write the following formula in Access. =COUNTIF($C$2:$C$9,$C2) I have attached a sample xls file, but wanted to test something like this in access. I understand the first part where I would write an IIF...

Hi, I am trying to write a query with 2 IIF arguments but it doesnt work. I have managed to get the first argument to work which will check to see if Europe = 0 and UK = 0 then this will put the value "Neither" (I put the and between 0 and [UK] to make it work). i have put the second IIF...

I am looking to write an Excel SumProduct but within a database and was wondering if somebody help guide me to any tutorials or help me to understand the basics of converting one to a database query. Thanks in advance.

Just a quick question, I have created a make table query and when this is ran it will overwrite my table "Table1". I now want to copy this query but want it to create a table called "Table2" now but how would i change this in the query? Could somebody please help. I know i would be able to...

I have the following query in Excel that I use to rank points against a queue: =SUMPRODUCT(--($G$4:$G$4431=$G4)*($J4>$J$4:$J$4431))+1 Column G = Queue Name Column J = Points the query above is what i have in column 4. What I would like to do is run a query in access that would do the same...

Hi, I am writing a couple of macros in Access 2007 to add data within a table and empty the data from the table as well. I have managed to write a "TransferSpreadsheet" to add the data but don't know how to write one to empty the table (leaving the headers in). Would i need to write a query...

Hi, I am trying to work out how to get a unique count for the following table: ID | Agent 11 | 1 11 | 1 11 | 2 22 | 3 22 | 3 I write the following query: SELECT Table1.ID, Count(Table1.Agent) AS CountOfAgent FROM Table1 GROUP BY Table1.ID; which gives me the total of agents: ID |...

Hi, I have ran the following query to combine 2 query results, but i get duplicate data showing up. I have duplicate ID (1,1,2,2) and Names as well. I was aware that if i take the ALL out the Union this would combine the duplicates into 1 line, but this hasnt worked. Where have i gone wrong...