473,386 Members | 1,830 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,386 software developers and data experts.

Sum text boxes / from subform question

Hello

Sorry everyone, I am back again - I have tried to find the answer and after 2 hours of not getting anywhere I have finally given in.

I have a form with several text boxes which are totaling from several subforms. These are fine when there is data in the subforms. However when there isn't any data in the form i would like it to give £0.00 as the sum, so the rest of the calculations can still work. If the subform doesnt have data the calculations I do on that sum doesn't return anything.

Or perhaps I could get the additional sum I am trying to calculate on the sum text boxes to ignore nulls?

At a complete mind block!

Many Thanks


D
Jul 22 '07 #1
2 1544
Hello

Sorry everyone, I am back again - I have tried to find the answer and after 2 hours of not getting anywhere I have finally given in.

I have a form with several text boxes which are totaling from several subforms. These are fine when there is data in the subforms. However when there isn't any data in the form i would like it to give £0.00 as the sum, so the rest of the calculations can still work. If the subform doesnt have data the calculations I do on that sum doesn't return anything.

Or perhaps I could get the additional sum I am trying to calculate on the sum text boxes to ignore nulls?

At a complete mind block!

Many Thanks


D
Finally discovered how to do it! And thought I'd share lol...

In the control source of the text box:

=IIf(IsNull([Text85]),"0",([Text85]))

This will show "0" instead of " " if that makes sence??
Jul 22 '07 #2
xpun
39
Finally discovered how to do it! And thought I'd share lol...

In the control source of the text box:

=IIf(IsNull([Text85]),"0",([Text85]))

This will show "0" instead of " " if that makes sence??

Instead of going through all of that trouble why not just set the format of those textboxes to currency
Jul 25 '07 #3

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

Similar topics

7
by: Gertjan van Heijst | last post by:
Hi, I really hope someone can help me because I've already spend 2 days on this problem and I'm not getting anywhere. I think the problem is that I don't really understand how text boxes store...
3
by: ChadDiesel | last post by:
I'm new to Access and need some advice. I am trying to setup a database to print labels and reports for our shipments. I have set up a table with fields such as I have taken a snapshot of what...
1
by: ChadDiesel | last post by:
I'm new to access and need some help. I have a form with a shipment destination at the top. I then have a subform that I enter boxes for that shipment. I have several shipments going at a...
13
by: Shannan Casteel via AccessMonster.com | last post by:
I set up two tables (one with the regular claim info and another with ClaimNumber, PartNumber, and QuantityReplaced). The ClaimNumber is an autonumber and the primary key in both tables. I made a...
14
by: simonmarkjones | last post by:
Hi, I'm having a bit of trouble editing an old database that was created quite a while ago by someone else. There is a form that lets the user select a member of staff and show details about the...
7
by: badboybrown | last post by:
I know that this is an age old question and it has been approached a few times, but I've hit a wall and require some help. I have various combo boxes that contain values that are both "current"...
9
by: ielamrani | last post by:
Hi, I am trying to color a subform tab blue or red when 2 of its text boxes are not null. Here is my code that I tried but it's not working: If Forms!.First Is Not Null And Forms!.Last Is Not...
1
by: kickergirl | last post by:
I'm not sure my title actually describes my problem, but here it goes. I am creating a form to track account information for participants. Basically, a single participant can be offered up to...
11
by: jwessner | last post by:
I have a form (Form1) which contains basic Project data and a subform listing the personnel assigned to the Project as a continuous form. Selecting a person on that project and clicking on a command...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

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.