No Value

  • Thread starter Thread starter Donna
  • Start date Start date
D

Donna

trying to sum two fields but one field is empty. It is
not Null it contains No Value. How can I set this field
equal to Null?
 
Donna said:
trying to sum two fields but one field is empty. It is
not Null it contains No Value. How can I set this field
equal to Null?
Click to expand...

What does that mean, "it contains No Value"? Do you mean it's a text
field and contains the string "No Value"? Are you talking about fields
in a table, or controls on a form? If they are fields, what are their
data types? If they are controls, are they bound controls, and if so,
what are the data types of the fields to which they are bound?
 
-----Original Message-----


What does that mean, "it contains No Value"? Do you mean it's a text
field and contains the string "No Value"? Are you talking about fields
in a table, or controls on a form? If they are fields, what are their
data types? If they are controls, are they bound controls, and if so,
what are the data types of the fields to which they are bound?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...


the controls are in a form. the one that I am having
problems with is summing a bound control in the detail
section, but that table is empty(sometimes needs to be
empty).

frmTest.amounts
(this is in the detail section of the form)
frmTest.PaymentAmounts =Sum(frmTest.amounts)
this is the one that has no value.

in a second form-the table for this form is never empty.
frmInv.amounts
(this is in the detail section of the form)
frmInv.ttlInvAmounts =Sum(frmInv.amounts)


in a third form control (text box) I am trying to find the
balance.
frmInv.ttlInvAmounts - frmTest.PaymentAmounts

all of the controls and table fields are set to currency.
 
Donna said:
the controls are in a form. the one that I am having
problems with is summing a bound control in the detail
section, but that table is empty(sometimes needs to be
empty).

frmTest.amounts
(this is in the detail section of the form)
frmTest.PaymentAmounts =Sum(frmTest.amounts)
this is the one that has no value.

in a second form-the table for this form is never empty.
frmInv.amounts
(this is in the detail section of the form)
frmInv.ttlInvAmounts =Sum(frmInv.amounts)


in a third form control (text box) I am trying to find the
balance.
frmInv.ttlInvAmounts - frmTest.PaymentAmounts

all of the controls and table fields are set to currency.
Click to expand...

Sorry, but I'm still having trouble figuring out how you have this set
up, possibly because your naming convention is confusing to me. I'm
quite sure your problem has an easy solution, but I need to pin down the
details. I hope you don't mind answering a few specific questions, some
of which you may feel you've already given me the answers to:

1. Are there multiple forms involved in the problem you want to solve?

2. What are the names of the forms involved?

3. Are there subforms involved, and if so, on what main forms? What are
the names of the subform controls (on the main forms), and what are the
names of the forms that are being displayed in the subforms.

4. What are the names of the tables involved in the problem?

5. What are the recordsources of the forms involved in the problem?
Please include the SQL of any queries.

6. What are the names of the text boxes involved, as shown in the Name
property of each control's property sheet? Which one is showing the
problem?

7. What are the controlsources of the text boxes, as shown in the
Control Source property of each control's property sheet?

8. What form is each text box on?

The answers to these questions should help me get it straight in my head
so that I can help you. I suspect that the Keri Hardwick's nnz()
function, as posted here:

http://www.mvps.org/access/forms/frm0022.htm

is going to be the answer to your problem, but I don't yet know where to
use it. If you can get the answer you need from reading that web page,
then you needn't bother answering my questions.
 
Back
Top