Search results

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

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

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