Search results

That was exactly what I needed, thanks. Thanks also for introducing me to datasheet forms.

I tried this and got a '3075' run-time error: Syntax error (missing operator) in query expression 'Trim(3-Month Average & ")<>" And Trim(01/01/2016 & ")<>" And Trim(02/01/2016 & ")<>" And Trim(03/01/2016 & ")<>""

I want to hide rows, not columns. See attached for example -- rows with no values in all three months should be hidden.

I have a crosstab query that retrieves the last 3 months of data and finds the average for that period. However, the query returns many rows where the Current Total is zero or blank. How do I hide records for which the entire date range consists of zero/blank values (i.e., all three months are...

That was it -- thank you. Incidentally, the code needed the Invoice Month field as well: Running Hours: DSum("[Current Hours]","ITISS_Summary","[Labor Cat Desc]= '" & [Labor Cat Desc] & "' AND [Invoice Month]<=#" & [Invoice Month] & "# AND [ContractYear]= '" & [ContractYear] & "'")

I should probably mention that "Contract Year" itself is an expression within the same query. Is that a problem? When I try to run the updated code suggested by pbaldy, I get: The expression you entered as a query parameter produced this error: 'The object doesn't contain the Automation...

I want to add up the current hours for each position by month to create a running total ("Running Hours)". This running total should also reset from one contract year to the next. The result should look like this: Contract Year Invoice Month Labor Cat Desc Current Hours Running Hours...

That works - thanks!

Date is an actual, sortable date field. Dec-15 is stored as 12/1/2015, Jan-15 is 1/1/2016, and so on. As I mentioned in my initial post, the query works fine if I want to find changes in cost. I want to find changes in server names.

Sample data: server_name | date AAA001 Dec-15 AAA002 Dec-15 AAA003 Dec-15 AAA004 Dec-15 AAA005 Dec-15 AAA002 Jan-16 AAA003 Jan-16 AAA004 Jan-16 AAA005 Jan-16 AAA006 Jan-16 Query returns: current_server | previous_server | current_date | previous_date...

I have a server inventory table that gets updated monthly. The fields include server name, date, cost, etc. What I want is a query that identifies any servers that have been added or removed since the previous month (added or removed in the sense of they were used or not used in the current...