Recent content by Purdue15

Hello Everyone, I have a report that generates 100 items in alphabetical order. All of the items are also displayed in a table. I have a bound form attached to the that table, and when the items appear they are not in alphabetical order. Therefore, it is a hassle typing in the data when the...

Assuming everything is in one table you first need to create a design query and use the total function. From there you should select the column that contains "Same" and use the count function and then do the same for "Differences". This will give you a number of how many were admitted As for...

This worked thanks!

I have two functions IIf([NWeight]=" ",[CWeight],[NWeight]) And Round(([CWeight]-[NWeight])/[CWeight]*100,2) How do I combine these two together so that they can both run? The IIf statement needs to be completed before the Round statement in the function

Ok so you got me thinking in the right direction instead I'm using the IIf function in VBA IIf(IsNull(Me.txtWeight), Me.txtWeight, Me.ccrtWeight) this returns the value I want to if its NUll, although if its not null and I fill in the value it will still show me.ccrtWeight instead of...

Im trying to prevent an error message when running a query. I am still receiving the error with this function what I'm I doing wrong? Weight: Round(([CWeight]-Nz([NWeight],0))/[CWeight]*100,2) * NWeight is the only possible Null value which is why I only used Nz on it, I tried this also...

Ok well the C columns are always going to be completely filled out no matter what. The N columns are the only ones that will be empty and most of them will be empty if there wasnt a change. So a lot of times there will be very few changes. I tried this and it didnt work Nz([NWeight],'OK')

Here is the attachment

Im calculating error percentages and if the second number subtracted in the numerator is blank its should actually be 100 %, instead it displays #Error. Is there a way that I can type an iif statement in criteria so that if there is an error I can make it equal to something else like '0' or...

Thanks but it didnt work :confused:

:banghead: Ok! So I have previously asked this question before but now I have attached pictures so hopefully you can get a more clear understanding. So if you look at the Form you can see I am pretty much using this as an accuracy check. So I am only filling in things that are different. I...

Thats what I have been doing but for some reason there is always an error

How do I count only filled out data in a query? I am using the count function and it counts blank and filled out records, I just want the filled out ones. Please be specific thanks

I have a form that has two columns one column contains criteria that is correct and is bound to a table so it auto fills, and the other column is unbound for filling in criteria that is different. Some criteria is letters others are numbers. Each column has its own table that it is sent to...

(("Correct_Add([Weight)]-New_Add([Weight)]")/("Correct_Add([Weight)]"))*100