Search results

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 :)

Hi, I have a small issue where I do have names written in UPPER CASE, I would like to transform them in Capitalized (each word), I understand that I cannot use the same function as in excel (PROPER) but something like StrConv, but as I do have a ‘comma’ in between the names I have something...

I know sometimes I confuse myself, all is working now, as you mention I declare the first day for a given week so I should be OK. Thanks again

Hi Plog, Think I answer my question :-) I created the following: [CODE](SELECT Min(Tbl_Calendar.Date) FROM Tbl_Calendar WHERE Tbl_Telephony_All.WeekNbr =Tbl_Calendar.WeekNbr ) AS [Date] [CODE] and seems to work, don't know how... but it gives me the first date for that week Any different...

Thanks Plog, Understand what you mean, I had some issues in excel for the Gregorian calendar hence I used a ISO formula, but not relevant in this case :-). Now for this case, I do have a Calendar table running also, can you help me in getting a statement which would get the first day for a...

I have a database with weeks represented as yyyyww (201323), I need to extract the information for the previous 13 weeks, so far so good but the difficulty is that our calendar is different from the Gregorian one, as the year starts at the end of June e.g. 2013/14 Week 1 is from Friday, 28th...