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

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

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

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

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

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:

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

What is a function I can write under criteria that will count each value inside that column? For example [SELECT COUNT( * ) FROM "Weight"] Thanks

Hello world, I have two command add buttons on my form that go to two seperate tables. I also have a go to next record button as well. Is there a way that I can put all three commands under one command button? They are already coded in VBA and all work properly individually, I just want to...

Private Sub cmdNewAdd_Click() 'add data to table Dim strSQL As String strSQL = "INSERT INTO Correct_Add(SKU, Warehouse,Weight,ULength,UWidth,UHeight,CLength,CWidth,CHeight," & _ " WPT,GC2,GC3,PLAT,PFactor,SAFlag,CType,ABC,ShipType,CFlag,PPType, OptmLS, OptmLSU, ORMD, SFlag...

I dont know what is wrong at all! Private Sub cmdNewAdd_Click() 'add data to table Dim strSQL As String strSQL = "INSERT INTO CTracking(SKU, Warehouse)""Values('" & Me.ccrtSKU & "','" & Me.ccrtWarehouse & "')" CurrentDb.Execute strSQL End Sub

Hello World! Ok, so I am working on a project and I want some advice from some Access experts on the best way to get this accomplished. So I have a huge list of inventory 200,000 + I run a macro and I get a table with a sample of exactly 100 items. I then print of a report that has one column...