Search results

Feel dumb... :banghead: Tried so many different ways and the answer was so simple... Well when you know. Thanks for the help, forever grateful :)

The current path is: Y:\Sales Analysis\Analysis Team Folders\Service Team\Universe I would like something like: Y:\Sales Analysis\Analysis Team Folders\Service Team\Universe\Backups Thanks,

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 Paul, I am sure that I had tried something similar but for some reason didn't work, MANY THANKS the query is now doing what supposed to do. Cheers,:)

Hi Paul, Getting message "Cannot have aggregate function in GROUP BY clause (IIF(Tbl_SKG.Value_Grp = 1,sum(Tbl_Advisor_raw.ValuePay),0). Any idea?

Hi, Yes I think the issue is in the Group By, not sure what is missing, I've tried to enter: ValueGrp1, ValueGrp2, ValueGrp3; But doesn't work either, so really not sure what I am missing :confused: Thanks,

Hi, Yes I have the totals marked as "Expression" :banghead: Not sure how to insert a jpg to show. Thanks again for teh help,

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