Recent content by Portucale

Hi, This is a Telephony Transfer report and the data containing several columns, however there are two columns (Column A & Column B), which, in Column A contains the source of the call where Column B is where the call was Transferred; in another table I have a the distribution of the Call...

Hi Paul, Happy New Year. Thanks, for the hint, but I was hoping to cut these two queries and just run one from the table and have the two fields. Hope with the update (SQL of the queries) I better explained what I have...

Hi, I have a table containing WeekNbr UserID TagName CallType Transfer TransferCount The ‘CallType’ is the FROM and the ‘Transfer’ is TO My aim is to create a Query/Table which would show: WeekNbr UserID ‘FROM’ ‘TO’ I was able to create two queries for each of FROM and TO, but I would...

Hi, I am looking to achieve a column within a query which gives me the count of records that are equal to a string in a different field, e.g. Field1 Count aaa21 3 aab01 2 aaa21 3 aaa21 3 aab01 2 Any help and all the help is very much appreciated. Kind...

THANKS Paul, Is not a surprise to you that the code is working, I had a better look into the raw data and is amazing as not only can see #MULTIVALUE, ?, Blanks, names with space after the comma, or no space, there isn't any logic behind this, however it seems that your code is bypassing this...

Yes it works also for me, but when I run the query it gives me a Run-time error '5': Invalid procedure or argument.No idea what could be possible causing that :banghead:

Hi Paul, The code works perfect for the names that have a "space" after the 'comma' but in fact I do have some names without the space, like; Vitor,Fonseca and Vitor, Fonseca, can you help? I managed to get the full name for the names without the space (Vitor,Fonseca, but the result is Vitor...

Hi, I am trying to calculate 5 fields within my table in a query, but for some reason some rows do not calculate as not all the fields contain a value (blank field), is there anyway that I could bypass this issue? Thanks,

Hi Paul, I am going crazy, tried so many different things that I haven't realized that the first instance was to be entered in the design mode... Thanks Paul and Bob for the help

Hi Paul, Thanks for the help, but I am having issues with putting it to work, see pic, am I doing anything wrong? It works OK in the Immediate Window, but for some reason not in the query :banghead: Cheers

I guess that there isn't any duplicates in the Employee Number field, so why not put them as a primary key and thereafter join the Employee Number.

Thanks Bob, works like a dream, although I've just noticed that the first part is in fact the Surname and the Forename is after the comma, is there any way to revert the names :)

Hi Bob, Using in Access 2010 in a query. But I think I find out why is not working for me... there isn't any blank space after the 'comma'... so seems that is recognizing the whole word as one and not as two.:banghead:

Hi, I am not saying it doesn't work, but I must be doing something wrong as it didn't work for me... This is what i get when I use the StrConv(Tbl_Telephony_Temp.Agent,3) Agent Expr1001 MCLAUGHLIN,ALLAN Mclaughlin,allan I am confused!!:banghead: Thanks guys for the...

Thanks, but that would give me only the First Name with Uppercase as Vitor, fonseca, when I need to have Vitor, Fonseca :)