Search results

Thanks pbaldy. I have added the brackets but this gives me an "invalid bracketing error" This is the sql: SELECT ID, Count(ID) AS CountOfAgent FROM [SELECT DISTINCT ID, [Agent Name] FROM Table1]. AS D GROUP BY ID; Thanks once again.

Thanks Stopher, that works brilliantly. I was just wondering if the column name was Agent Name rather than Agent would i edit like the following: SELECT ID, Count(ID) AS CountOfAgent FROM [SELECT DISTINCT ID, Agent Name FROM Table1]. AS D GROUP BY ID; as this gives me a syntax error, where...

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

namliam, i have ran another query on the back of the union query, but when summing the agent name i get a data type mismatch in criteria expression. So i tried this on the pass and fail columns but it still does not work? where am i going wrong?

thanks for your replies Rik_StHelens and namliam. rik, the problem being is that the data in the two tables are coming from different sources hence the problem of the different conventions of name usage occurs. namliam, i have used a normal UNION rather than a UNION ALL.

I have ran a union query that combines two tables but i now need to combine the duplicates as 1. The following are the results i get and the issues that i am having: ID | Name | Pass | Fail 10 | AAA | 10 | 2 10 | AA | 10 | 2 | BBB | | 13 23 | bbb | 89 | 40 | A B | | 2 40...

I have 3 tables. 1 table of names, 1 table of Queue A results, 1 table of Queue B results. What i would like to do is run one query that will combine the table of names, and give me their set of results. For example: Table of Names Humpty Dumpty Mickey Mouse Queue A Results Humpty | 2 Dumpty...

Thanks pbaldy, ill have a look at how to create a union query. thanks once again.

I have managed to write a query that counts a persons name to give me a figure of how many times a person appears in another table. What i would like to do is to add a total field in the last cell, for example: Humpty | 8 Dumpty | 3 Mickey | 2 Mouse | 9 TOTAL | 22 If somebody could please...

Hi, I am a newbie to Access and I quite eager to learn how it all works. I was wondering if somebody could guide me to any websites or books with tutorials on how to create different types of databases along with various queries that i could create... Thanks in advance.

thanks namliam.

Thanks boblarson, that works perfectly. Thanks for your help as well Scooter. Just out of curiosity and for my knowledge what does IIf stand for?

Thanks Scooter and Bob, i will give that a go and let you know how i get on.

I have two columns of numbers within my access db like the following: 80 | 8 27 | 4 14 | 0 4 | 0 210 | 0 What i would like to do is write a query that would divide the first column by the 2nd and give me a figures in %. Is this possible within Access? Please could somebody help. Thanks...

Hi, I was wondering how i would display Time Values that are over 24 hours in Access. Currently within Excel I have 3 values: 35:06:40 47:26:15 01:25:30 When importing this table with these values I get the following: 01/01/1900 11:06:40 01/01/1900 23:26:15 01:25:30 From what I can see...

Thanks Brian, I managed to write the following query (all due to your help) INSERT INTO Sample ( [Friendly Queue Name] ) SELECT SampleWeek.[Friendly Queue Name] FROM tblesub LEFT JOIN Sample ON SampleWeek.[Friendly Queue Name] = Sample.[Friendly Queue Name] WHERE (((Sample.[Friendly Queue...

Unfortunately the master table does not consist all the queues. So will need to workout how to add a queue name if their is no match with the master. Is their a possibility to write some sort of code or query? Sorry to be a pain by the way, thanks for all your help. aftabn10

Thanks Brian that works perfectly. Just out of curiosity what would happen if a new Queue Name appeared in the Weekly Table that didnt exist in the Master Table? Would this be automatically added into the Master? Thanks once again for all your help.

Thanks for your reply Brian. Basically what i mean here is that master table will have some queues that might not appear within the weekly table: For example: WE30.10.09 table their was no data for Queue 3 so when linking the two tables Queue 3 should show up with no data e.g. Queue Name |...