Search results

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

Hello World,I have two tables one named Correct_Add and the other New_Add. In each table I have the same categories Weight, Height etc. I want to find the percentage difference between each category. I know I need to write an expression but I am a little confused on the format. Right now I have...

Hello World, I want to display a custom message box when I open my query. Can someone please tell me how to do this? Thanks!:cool:

The file is to large I cant

Yes but for some reason it counts the total number even if its blank, so if i have 34 rows the total for each column is 34 for each. instead of 30 31 28 34 etc..

Ok now I have two tables in a query, I plan to use a couple of columns from one. Then for the rest of my columns I want the totals of each. So I have I clicked totals to show total and have clicked Count, then for criteria I have Is Not Null. I know this is simple but I cant seem to get it to work