473,322 Members | 1,421 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Microsoft Access form

I am trying to calculate a total in a text box for a column on an Access form. There are 4 text boxes in this column (Material Hauled Amount, Haul Back Amount, Dentention Time Amount, and Stop Over Amount). Some of the text box values in the column will be null because they are optional. I can't get the total to calculate. I have tried the IIf and the Nz expressions, but couldn't get them to work (I'm not sure if I was putting these expressions in the right place). What can I do to get the total? I don't want the null values to be replaced on the form by zeros. I want to leave them blank on the form. Please help!
Jul 16 '11 #1

✓ answered by Rabbit

Expand|Select|Wrap|Line Numbers
  1. =Nz(Field1, 0) + Nz(Field2, 0) + Nz(Field3, 0) + Nz(Field4, 0)

1 1226
Rabbit
12,516 Expert Mod 8TB
Expand|Select|Wrap|Line Numbers
  1. =Nz(Field1, 0) + Nz(Field2, 0) + Nz(Field3, 0) + Nz(Field4, 0)
Jul 16 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Arend Jan Nijenhuis | last post by:
Hi, I'm fairly new to .Net, but an expert in Microsoft Access VBA. For a large Access application, I want to create some sort of custom control (COM interop?) in VB.Net, to be used in an Access...
17
by: Pam Ammond | last post by:
I need to use Microsoft Access Automation within a Visual Studio 2003 program written in C# for Windows Forms. When a button is clicked in my VS.NET program, I want it to run a Microsoft Access...
1
by: SortaNortth | last post by:
Is it possible to code to a VB.NET windows form button to open a Microsoft Access Form? If so, which namespace(s)/class(es) would I use in doing the coding? Are there any good reference books...
4
by: bbdobuddy | last post by:
Hi, How do I open a Microsoft Access 2003 form from Visual Basic.net Thanks in advance bbdobuddy
1
by: somersbar | last post by:
hey, ive been trying to set up a web form in visual basic.net that can access a microsoft access database. i need to use odbc also. i can get it working using a windows form but not a web form....
6
by: Jack | last post by:
Hi, I have an Access application which need to be converted to asp-sql server application. This Access application uses a single form. This form has got a SS number with names and age. The form...
2
by: cci_ceo | last post by:
I am using vb 2005. IHow do I pass information from an microsoft access form to a vb form and back?
7
by: buddyr | last post by:
Hello, I am in microsoft access form - I want a field called serial number to have number display with 3 zeros before it. the serial number is always 5 digits. I have tried putting "00000000" in...
3
by: buddyr | last post by:
I am scanning a barcode into first textbox on a microsoft access form. When I scan barcode - the number does not appear in textbox. When I tab to next textbox - it appears. Is there a way to have it...
2
by: buddyr | last post by:
Hello, I saw an example of microsoft access form based on table. the form had combo box to select employee and and then labels and textboxes below. The form had a pie chart that changed to...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.