Search results

Got it working: SELECT [Influent Data - Monthly Summary Sheet].[SumOfTotal Flow (m3/day)]/1000 AS Expr2, ([Influent Data - Monthly Summary Sheet].[SumOfTotal Flow (m3/day)]/1000)/[Influent Data - Monthly Summary Sheet].[SumOfNumber of Samples] AS [Average Total Flow], Max([Influent Data].[Max...

Bob - The Date/Time attribute is applied, but only the date is recorded (no time). So you're saying there is no way to salvage anything I've done with the above code?

Correct, [The Date] is a field in each table that is auto-recorded when a new data entry is made. It is the Date/Time property and is in the form dd/mm/yyyy. Return Sludge shouldn't be in there and has been removed. There are prompts in the other queries, asking for the same time range (a...

QBE grid to start, then manual edits. Here's the updated code: SELECT [Influent Data - Monthly Summary Sheet].[SumOfTotal Flow (m3/day)]/1000 AS [Total Flow], [R1 Data By Month].[Total Flow]/[Influent Data - Monthly Summary Sheet].[SumOfNumber of Samples] AS [Average Total Flow]...

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

You're a magician. Thanks so much for your help!

Now - I guess one more question - If I wanted to have a report that had the monthly summaries (using Taruz's function) for the year, how would I go about doing that? It would just prompt the user to enter the year and then all the monthly summaries (with the values summed) would appear.

Hi Taruz - That Worked perfectly!

Alright, here is a code snippet: SELECT [Aeration Data].[The Date], [Aeration Data].[30 Minute Settling Test], [Aeration Data].[MLSS (mg/L)], [Aeration Data].[MLVSS (mg/L)], [Aeration Data].[Ammonia In (mg/L)], [Aeration Data].[Ammonia Out (mg/L)], [Aeration Data].[Ortho-Phosphorus In (mg/L)]...

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

I got it working... I took out the following from the code: (Departments.[Department Name] = [Absenteeism 2011].Department)

I was thinking of having the admins just copy and paste the table for the new year.. is there a better way to do it?

Hahaha, Not my system..

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

Alright I think I've gotten something here, could you elaborate on how I could hook this up to the initial text box? SELECT Departments.[Department Name] FROM [Absenteeism 2011] AS [Absenteeism 2011_1], Departments INNER JOIN [Absenteeism 2011] ON Departments.[Department Name] = [Absenteeism...

@pbaldy - I'll give this a shot... looks like exactly what I need. @boblarson - I'm using a form to save information to a table, then running queries on it which require the autofilled information.

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

Bah! It was the numbers in quotes. Thanks a ton man! Have a great weekend!

Alright, one number changed.. I'm still only getting 2 weeks and 6 weeks for numbers.. Any ideas? iif ([Number of Years in Service]<="3" AND [Number of Years in Service]>"1", "2 Weeks", iif ([Number of Years in Service]<="10" AND [Number of Years in Service]>"3", "3 Weeks", iif ([Number of...

Alright, I'm getting some weird errors now: 33.29 gives me 2 weeks whereas 6.36 gives me 6 weeks. iif ([Number of Years in Service]<="3"&[Number of Years in Service]>"1", "2 Weeks", iif ([Number of Years in Service]<="10"&[Number of Years in Service]>"3", "3 Weeks", iif ([Number of Years in...