Search results

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

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

Hi, I have a code which creates a backup of my project on open as a AutoExec, but it creates the Backup in the current path, I would like to change the current path to a different one. Sub Backup() Dim dTime As Date Dim sFile As String, oDB As DAO.Database Dim oTD As TableDef On...

Hi everyone, I have a make table query that gets its info from another table that is updated weekly. I would like that when we run the Query Type (Make Table), we would like to add a primary key to a field that exists already starting at 1 every time the query is run. Thanks in advance,

Hi, I am trying to aggregate IIF functions to give me the total in separate columns (fields) according to the criteria applied however I am getting an error message "You tried to execute a query that does not include the specific expression 'IIF(Tbl_SKG.Value_Grp =...

Hi, A bit I a muddle with a particular query that I am trying to build. Have a table with data from 12 months and want to build a query which would give me the results for the last 6 months in separate fields (columns), I understand that in T-SQL we can build CASE Statement but seems that is...

Hi, My name is Vitor and originally from Portugal, I live in Edinburgh, Scotland. I work as a Senior Analyst, and have some knowledge of Access, although I do require help time to time. Feel free to contact me for any thing as I may be able to help also. Cheers

Hi, Please accept my apologies if I am posting this issue in a wrong place but not sure what to do anymore. I am trying to provide some analysis on HITS into a particular web page, the same is connected to a Access Database. I have a asp page which is connected to a access database only...