Form Claculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table containing values that are to be calculated against payments
on a form. So therefore the payment value is to be deducted from the total
amount due in the table and then show the updated total on the form, this
then consequently updates to a secondary table for referance and query
purposes. However the calculation constantly leaves me with a NAME error. It
is very similar to cross spreadsheet calculations in Excel just now using
forms. Please help!
 
The "Name" of one of the elements of your calculation does not exist, or
most usually... is mispelled.
Given... = [Field1] + [Field2] + [Fild3] would cause a name error because
of the spelling of the 3rd element.
Without your field names (exactly) and your calculation (exactly) there's no
way for us to tell for sure what's wrong.

--
hth
Al Camp
Candia Computer Consulting - Candia NH

http://home.comcast.net/~cccsolutions
 
The one tables name is cfx and contains a field called Capital at Risk. The
other forms name is Promise to pay (which updates to the Promise to pay
table) with fields called RealAmount and SuggestedAmount contained therein
and anyone of these may be zero and therefore I utilize the nz function. So
my formula that I entered looks like this.

=([cfx!Capital At Risk])-nz([RealAmount])+nz([SuggestedAmount])

Any suggestions on what cold be wrong. I checked the spelling and this still
gives me the name error.

Thanks for the help thus far and I trust that this may be the key to solving
this problem with the example formula supplied above.
--
Hangnail


Al Camp said:
The "Name" of one of the elements of your calculation does not exist, or
most usually... is mispelled.
Given... = [Field1] + [Field2] + [Fild3] would cause a name error because
of the spelling of the 3rd element.
Without your field names (exactly) and your calculation (exactly) there's no
way for us to tell for sure what's wrong.

--
hth
Al Camp
Candia Computer Consulting - Candia NH

http://home.comcast.net/~cccsolutions
William said:
I have a table containing values that are to be calculated against payments
on a form. So therefore the payment value is to be deducted from the
total
amount due in the table and then show the updated total on the form, this
then consequently updates to a secondary table for referance and query
purposes. However the calculation constantly leaves me with a NAME error.
It
is very similar to cross spreadsheet calculations in Excel just now using
forms. Please help!
Click to expand...
Click to expand...
 
I can see why this is failing, but a solution requires more info.

I take it that CapitalAtRisk (try not to use spaces in field names... if you
do, they must always be bracketed) is in a table somewhere, and that value
is not on the form?

Is it just a single constant value, or does your table contain many
CapitalAtRisk values?

If so, what is the relationship between the data on your form vs. the
correct CapitalAtRisk value you need from the table.

RealAmount amd SuggestedAmount are on the form, so you're "calling" them
properly. It's the CapitalAtRisk that is the problem. Please respond to
the above questions, and provide a description of CFX and CapitalAtRisk and
how it realtes to your form and the values on the form.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions



William said:
The one tables name is cfx and contains a field called Capital at Risk.
The
other forms name is Promise to pay (which updates to the Promise to pay
table) with fields called RealAmount and SuggestedAmount contained therein
and anyone of these may be zero and therefore I utilize the nz function.
So
my formula that I entered looks like this.

=([cfx!Capital At Risk])-nz([RealAmount])+nz([SuggestedAmount])

Any suggestions on what cold be wrong. I checked the spelling and this
still
gives me the name error.

Thanks for the help thus far and I trust that this may be the key to
solving
this problem with the example formula supplied above.
--
Hangnail


Al Camp said:
The "Name" of one of the elements of your calculation does not exist, or
most usually... is mispelled.
Given... = [Field1] + [Field2] + [Fild3] would cause a name error
because
of the spelling of the 3rd element.
Without your field names (exactly) and your calculation (exactly) there's
no
way for us to tell for sure what's wrong.

--
hth
Al Camp
Candia Computer Consulting - Candia NH

http://home.comcast.net/~cccsolutions
William said:
I have a table containing values that are to be calculated against
payments
on a form. So therefore the payment value is to be deducted from the
total
amount due in the table and then show the updated total on the form,
this
then consequently updates to a secondary table for referance and query
purposes. However the calculation constantly leaves me with a NAME
error.
It
is very similar to cross spreadsheet calculations in Excel just now
using
forms. Please help!
Click to expand...
Click to expand...
Click to expand...
 
The CFX is just an abbreviation for a table name, which contains the monthly
financial updates for all the clients within our portfolio (a debt collecting
company). So yes per month, per client there is a new Capital at Risk amount
provided.

As per the Capital at Risk naming this I've done this and the error remains,
however after experimenting with the formula a bit furhter I now have an
ERROR message instead of an NAME error.

Below I have listed the new formula that I have tried:

=Sum(cfx!CapitalAtRisk)-nz(([RealAmount])+([SuggestedAmount]))

The correct Capital at Risk would be the latest one for the current month
that has been provided. The amounts provided are date driven as per the date
of delivery of the file with the relevant updates (CFX). Therefore somehow
or another I think I will have to enforce a check within the formula to
ensure that it looks at the last amount provided per customer per month.

Thanks a million for the responses thus far, I really appreciate it. Take
care.
--
Hangnail


Al Camp said:
I can see why this is failing, but a solution requires more info.

I take it that CapitalAtRisk (try not to use spaces in field names... if you
do, they must always be bracketed) is in a table somewhere, and that value
is not on the form?

Is it just a single constant value, or does your table contain many
CapitalAtRisk values?

If so, what is the relationship between the data on your form vs. the
correct CapitalAtRisk value you need from the table.

RealAmount amd SuggestedAmount are on the form, so you're "calling" them
properly. It's the CapitalAtRisk that is the problem. Please respond to
the above questions, and provide a description of CFX and CapitalAtRisk and
how it realtes to your form and the values on the form.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions



William said:
The one tables name is cfx and contains a field called Capital at Risk.
The
other forms name is Promise to pay (which updates to the Promise to pay
table) with fields called RealAmount and SuggestedAmount contained therein
and anyone of these may be zero and therefore I utilize the nz function.
So
my formula that I entered looks like this.

=([cfx!Capital At Risk])-nz([RealAmount])+nz([SuggestedAmount])

Any suggestions on what cold be wrong. I checked the spelling and this
still
gives me the name error.

Thanks for the help thus far and I trust that this may be the key to
solving
this problem with the example formula supplied above.
--
Hangnail


Al Camp said:
The "Name" of one of the elements of your calculation does not exist, or
most usually... is mispelled.
Given... = [Field1] + [Field2] + [Fild3] would cause a name error
because
of the spelling of the 3rd element.
Without your field names (exactly) and your calculation (exactly) there's
no
way for us to tell for sure what's wrong.

--
hth
Al Camp
Candia Computer Consulting - Candia NH

http://home.comcast.net/~cccsolutions
I have a table containing values that are to be calculated against
payments
on a form. So therefore the payment value is to be deducted from the
total
amount due in the table and then show the updated total on the form,
this
then consequently updates to a secondary table for referance and query
purposes. However the calculation constantly leaves me with a NAME
error.
It
is very similar to cross spreadsheet calculations in Excel just now
using
forms. Please help!
Click to expand...
Click to expand...
Click to expand...
 
(cfx!CapitalAtRisk) will not access the value of CapitalAtRisk if it resides
in a table exterior to your form, and is not on the form itself.
You'll have to use an "aggregate" function to "look up" the CapitalAtRisk
value in CFX.

IF... the CapitalAtRisk value you want to use is (as you seem to infer in
your response) always the LAST value in the CFX table then... (use your own
names)
=DLast("[CapitalAtRisk]","tblCFX") - nz(([RealAmount])+([SuggestedAmount]))
should do it.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

William said:
The CFX is just an abbreviation for a table name, which contains the
monthly
financial updates for all the clients within our portfolio (a debt
collecting
company). So yes per month, per client there is a new Capital at Risk
amount
provided.

As per the Capital at Risk naming this I've done this and the error
remains,
however after experimenting with the formula a bit furhter I now have an
ERROR message instead of an NAME error.

Below I have listed the new formula that I have tried:

=Sum(cfx!CapitalAtRisk)-nz(([RealAmount])+([SuggestedAmount]))

The correct Capital at Risk would be the latest one for the current month
that has been provided. The amounts provided are date driven as per the
date
of delivery of the file with the relevant updates (CFX). Therefore
somehow
or another I think I will have to enforce a check within the formula to
ensure that it looks at the last amount provided per customer per month.

Thanks a million for the responses thus far, I really appreciate it. Take
care.
--
Hangnail


Al Camp said:
I can see why this is failing, but a solution requires more info.

I take it that CapitalAtRisk (try not to use spaces in field names... if
you
do, they must always be bracketed) is in a table somewhere, and that
value
is not on the form?

Is it just a single constant value, or does your table contain many
CapitalAtRisk values?

If so, what is the relationship between the data on your form vs. the
correct CapitalAtRisk value you need from the table.

RealAmount amd SuggestedAmount are on the form, so you're "calling" them
properly. It's the CapitalAtRisk that is the problem. Please respond to
the above questions, and provide a description of CFX and CapitalAtRisk
and
how it realtes to your form and the values on the form.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions



William said:
The one tables name is cfx and contains a field called Capital at Risk.
The
other forms name is Promise to pay (which updates to the Promise to pay
table) with fields called RealAmount and SuggestedAmount contained
therein
and anyone of these may be zero and therefore I utilize the nz
function.
So
my formula that I entered looks like this.

=([cfx!Capital At Risk])-nz([RealAmount])+nz([SuggestedAmount])

Any suggestions on what cold be wrong. I checked the spelling and this
still
gives me the name error.

Thanks for the help thus far and I trust that this may be the key to
solving
this problem with the example formula supplied above.
--
Hangnail


:

The "Name" of one of the elements of your calculation does not exist,
or
most usually... is mispelled.
Given... = [Field1] + [Field2] + [Fild3] would cause a name error
because
of the spelling of the 3rd element.
Without your field names (exactly) and your calculation (exactly)
there's
no
way for us to tell for sure what's wrong.

--
hth
Al Camp
Candia Computer Consulting - Candia NH

http://home.comcast.net/~cccsolutions
I have a table containing values that are to be calculated against
payments
on a form. So therefore the payment value is to be deducted from
the
total
amount due in the table and then show the updated total on the form,
this
then consequently updates to a secondary table for referance and
query
purposes. However the calculation constantly leaves me with a NAME
error.
It
is very similar to cross spreadsheet calculations in Excel just now
using
forms. Please help!
Click to expand...
Click to expand...
Click to expand...
 
Thanks a million Al I will be in contact soon to let you know how it worked
out. Thanks again.
--
Hangnail


Al Camp said:
(cfx!CapitalAtRisk) will not access the value of CapitalAtRisk if it resides
in a table exterior to your form, and is not on the form itself.
You'll have to use an "aggregate" function to "look up" the CapitalAtRisk
value in CFX.

IF... the CapitalAtRisk value you want to use is (as you seem to infer in
your response) always the LAST value in the CFX table then... (use your own
names)
=DLast("[CapitalAtRisk]","tblCFX") - nz(([RealAmount])+([SuggestedAmount]))
should do it.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

William said:
The CFX is just an abbreviation for a table name, which contains the
monthly
financial updates for all the clients within our portfolio (a debt
collecting
company). So yes per month, per client there is a new Capital at Risk
amount
provided.

As per the Capital at Risk naming this I've done this and the error
remains,
however after experimenting with the formula a bit furhter I now have an
ERROR message instead of an NAME error.

Below I have listed the new formula that I have tried:

=Sum(cfx!CapitalAtRisk)-nz(([RealAmount])+([SuggestedAmount]))

The correct Capital at Risk would be the latest one for the current month
that has been provided. The amounts provided are date driven as per the
date
of delivery of the file with the relevant updates (CFX). Therefore
somehow
or another I think I will have to enforce a check within the formula to
ensure that it looks at the last amount provided per customer per month.

Thanks a million for the responses thus far, I really appreciate it. Take
care.
--
Hangnail


Al Camp said:
I can see why this is failing, but a solution requires more info.

I take it that CapitalAtRisk (try not to use spaces in field names... if
you
do, they must always be bracketed) is in a table somewhere, and that
value
is not on the form?

Is it just a single constant value, or does your table contain many
CapitalAtRisk values?

If so, what is the relationship between the data on your form vs. the
correct CapitalAtRisk value you need from the table.

RealAmount amd SuggestedAmount are on the form, so you're "calling" them
properly. It's the CapitalAtRisk that is the problem. Please respond to
the above questions, and provide a description of CFX and CapitalAtRisk
and
how it realtes to your form and the values on the form.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions



The one tables name is cfx and contains a field called Capital at Risk.
The
other forms name is Promise to pay (which updates to the Promise to pay
table) with fields called RealAmount and SuggestedAmount contained
therein
and anyone of these may be zero and therefore I utilize the nz
function.
So
my formula that I entered looks like this.

=([cfx!Capital At Risk])-nz([RealAmount])+nz([SuggestedAmount])

Any suggestions on what cold be wrong. I checked the spelling and this
still
gives me the name error.

Thanks for the help thus far and I trust that this may be the key to
solving
this problem with the example formula supplied above.
--
Hangnail


:

The "Name" of one of the elements of your calculation does not exist,
or
most usually... is mispelled.
Given... = [Field1] + [Field2] + [Fild3] would cause a name error
because
of the spelling of the 3rd element.
Without your field names (exactly) and your calculation (exactly)
there's
no
way for us to tell for sure what's wrong.

--
hth
Al Camp
Candia Computer Consulting - Candia NH

http://home.comcast.net/~cccsolutions
I have a table containing values that are to be calculated against
payments
on a form. So therefore the payment value is to be deducted from
the
total
amount due in the table and then show the updated total on the form,
this
then consequently updates to a secondary table for referance and
query
purposes. However the calculation constantly leaves me with a NAME
error.
It
is very similar to cross spreadsheet calculations in Excel just now
using
forms. Please help!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top