Search results

nope, I see no "thumb"

CJ London - Thank you, I was heading down the IIf path, but was trying everything but "0". Where is the "Thanks Button" (as mentioned in your footer).

on my form, I have a number of textboxes that perform calculations. As long as there is data in the corresponding cells, everything works well. The issue I am having (this is more cosmetic than anything), is to not show the errors in these boxes before data is entered. I have one showing...

Thank you, I caught the error in the IIF statements and I have the formula working fine.

Another piece of my puzzle is adding a webcontrol so when we enter the From/To locations, an online map will display the route and distance, which we will in turn use for selecting the proper Zone for mileage. Right now, I have the control opening Google Maps and after many hours, I found the...

that's under Format property isn't it? I have been looking at the Data tab. Thank you

I have 4 textboxes in my form which may or may not contain numbers (Qty) I need to add these together into a fifth textbox to use in a calculation. All that happens when I add the together is they are concatenated. how do I convert the textbox contents to a number format? The current formula...

if found a solution for this: =( Nz(txtAvgMPH1, 0) + Nz(txtAvgMPH2, 0) + Nz(txtAvgMPH3, 0) + Nz(txtAvgMPH4, 0))/ ( If(IsNull(txtAvgMPH1), 0 ,1) + If(IsNull(txtAvgMPH2), 0 ,1) + If(IsNull(txtAvgMPH3), 0 ,1) + If(IsNull(txtAvgMPH4), 0 ,1))

Since posting, my problem, I went down the path of using an IIF statement. By and large, it works, except when all the fields are not complete. I am writing a form that will help our company estimate transportation costs. I have two combo fields from which I can select equipment types (more...

I have a textbox containing this formula: =Nz(((([txtAvgMPH1]+[txtAvgMPH2]+[txtAvgMPH3]+[txtAvgMPH4])/4),Nz(([txtAvgMPH1]+[txtAvgMPH2]+[txtAvgMPH3])/3),Nz(([txtAvgMPH1]+[txtAvgMPH2])/2),[txtAvgMPH1])) nothing was displaying after I filled in the associated textboxes on my form. I put a macro...

=DLookUp("[ZAMPH]","qryTranZones","[ZONE] = form!txtzone2") As I said, my dlookup works fine. I am just needing to figure out how to get an average of the four txtAvgMPH boxes. I am working on using Nz, but having an issue with the issue of when there is only one entry made and the other three...

I am creating a form that will be used to estimate transportation costs. I am using one table containing "zones" (different mileage ranges and an estimated average speed). On my form, I am allowing a user to enter up to 4 different types of equipment, a quantity, and a zone. Using DLOOKUP, I am...