Search results

I have the following in a query Avg: (nz([A],0)+nz([B],0)+nz([C],0))/(3-IIf(IsNull([A]),1,0)-IIf(IsNull([B]),1,0)-IIf(IsNull([C]),1,0)) which seems to work really well except when A, B, and C are all null. I would like it to show 0.

I have a running total query that seems to run but when I try to total the query results then Access will be "Not Responding". I tried to change it to a Make Table query because I need to use the running total result in another query. So I created a table but when I try to run the make table...

I have a file of transaction history from the accounting system. All of the payroll cash payments are coded as ZG. Payroll accruals are coded as ZC. I need a sum of payroll accruals by department that have the same date or later than the last payroll cash payment. How do I write that query?

I have two tables that are joined together. I am trying to multiple hours and rate and I have the following expression: Salary: IIF(Hrs=0,Null,((CCur(Rate*Hrs)) It works great except when Hrs are not null and Rate is null. I am getting #Error when I would like to get Null.

If my fiscal year ends 12/31 but the pay period doesn't end until 1/10, how do I get a query to tell me there are 25.3 pay periods remaining (counting from the last pay period 1/11)?

I have a table that lists Cost Center, Partner, and Cost. I need a query to sum the cost when Cost Center and Partner do not match. How can I write that expression?

Hello! An engineer has turned me onto Access and I've been using it for a few months for various projects. I am not a programmer and I do not use SQL. I work with funding and I've found that Access is a great tool for comparing data as well as slicing and dicing to display data in different...