Search results

Are they null values? Maybe try <>0 or is not null

I'm not sure what you mean by not normalizing my data. Do you think I'm not trying to average values? I am trying to normalize my data. I have three sets of values, some of which have null. I am trying to get an average to hopefully get usable data for other queries. I'm getting 15687 records...

I'm not sure what indexes are. Could you elaborate?

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

This works really good. But, I have a slight problem when all three columns are null then I am getting #Error. Is there a way to tweak either this query or a second one? I would actually prefer the result to show 0 so I think that may be easier than having it show null. But I will take whatever...

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 got the answer, where AsOf is the pay period that just paid RemainPP: Round(((#12/31/2014#-[AsOf])/14),1)

Thanks to everyone who answered. I used this one but really because it was in the first answer and it's what made the most sense to me. IIF(Hrs=0 or Isnull(Rate),Null,((CCur(Rate*Hrs)) I'm not actually a programmer (not sure how obvious that is or will become).

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.

Yes, I just needed the "And" and it worked! There is no join. Thanks you!!:):D

Re: [this field] is less than [another field] I have qryA and tbl1 that do not have any joins. tb1 only has one field so I don't think there's a problem with that. I'm trying to get the solution to only show results when qryA.[this field] is less than tbl1.[another field]. This is what I put...

Pay periods are every two weeks. The pay period started 12/29/2013 and ended 1/11/2014. The next one started 1/12/2014 and ends 1/25/2014. People generally work Mon-Fri or paid holiday so we just exclude Sat-Sun for planning purposes. At the end of 2014, the pay period is looked as 3 days in...

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