Search results

Hi All, Here is my code: SELECT [Influent Data - Monthly Summary Sheet].[SumOfTotal Flow (m3/day)]/1000 AS [Total Flow], ([Influent Data - Monthly Summary Sheet].[SumOfTotal Flow (m3/day)]/1000)/[Influent Data - Monthly Summary Sheet].[SumOfNumber of Samples] AS [Average Total Flow]...

Hi All, I have a form setup where a person can enter data (5 fields) and the date autopopulates with code in the form (dd/mm/yyyy). What I need to be able to do is create a monthly summary and separate that by year. I know about the sum function, but without some way to normalize the dates...

Hi All, SELECT DISTINCTROW Departments.Director, Sum([Absenteeism 2011].Sick1) AS Sick1, Sum([Absenteeism 2011].Sick2) AS Sick2, Sum([Absenteeism 2011].Sick3) AS Sick3, Sum([Absenteeism 2011].Sick4) AS Sick4, Sum([Absenteeism 2011].Sick5) AS Sick5, Sum([Absenteeism 2011].Sick6) AS Sick6...

Hi, I'm trying to basically create something that when a 6 digit number is typed into the combo box, it will pull information from another table and auto populate the record in the database. IE: I type in 90210 and in another table, it says California and populates the form. Any advice on how...

Hi All, I've looked all over the internet.. What is wrong with my syntax? iif ([Number of Years in Service]=<3&>1, "2 Weeks", iif ([Number of Years in Service]=<10&>3, "3 Weeks", iif ([Number of Years in Service]=<16&>10, "4 Weeks", iif ([Number of Years in Service]<26&>16, "5 Weeks", iif...

Hi All, If I develop a database in Access 2007 and then try to open it in Access 2010, will it work? Thanks!