Field value contains "#Error"

Good morning,
I hope you are operating okay now - I assume "yes" by
your last post.

Best regards, hj

-----Original Message-----
Hello,
Yes, you're right: I changed a field name after I bump
into this error. I was able to use parameter in a
different way or display a numeric data including
percentages. here is one of the fields that I used
QueryA;
Calculated_Charges: Format(([Implementation]+[Payroll]+
[Tax_Filling]+[Training]+[HR/PR_Front_End]+
[Time_Attendance]+[Self_Service]+[Resource_Hire]+
[Benefit_Services]),"Currency")
Adusted_Charges: is similar to Calculated_Charges... so
from here I use this two fields to get a percentage from
its value.

"THANKS YOU"
-----Original Message-----
Hi,
By your answer I hear you say that QueryA, which
calculates Discount:, was working before and now is not
working in some cases. In your post of data samples I
see
some values are okay and some are #error. If nothing
has
happened to the code for QueryA, and the data base has
not
been altered (no query or table or field name changes,
etc.), then I feel there must be a problem with the data
to produce #error for some but not all instances of
Discount:.
If you would and can, please post (or pass me by
email)
a sample of QueryA output which displays
Calculated_Charges, Adjusted_Charges, and Discount:
which
includes both good and bad results.

This may take a little longer for me to get an exact
picture of your process. If you prefer we can discuss
this outside the user group by e-mail. Mine is
- without the ijk. Please
include "Access newsgroup error problem" in the subject
line.

We'll get there - hang in. I'm on Central Daylight Time
and online 8-4:30.
Regards, Howard

-----Original Message-----
Thanks again,
All the things that you wrote is correct; however,
having
said that... it was working before, and all the seturn
db/queries started not to dispay the correct data. if
there is anything I can do to fix this problem please
help
me. I'm just new using MS Access. Thanks

-----Original Message-----
Let me see if I have the picture now:
1. You have QueryA that calculates Discount: and
formats the result as "0.###%", and you have another
QueryB that uses QueryA as a recordsource and which
contains the parameter statement asking for the user
to
select a discount value.
2. By your other post showing calculation results
(from QueryA?), some calculations return #error.

If this is the correct picture, then I think you
might
have a data problem.
a. Some values of Calculated_Charges may be =0 or
null. Calculated_Charges is a denominator and should
not
=0 or be null. Suggest you print values of
Calculated_Charges to see if this is true in cases
where
Discount: = #error. If true, values of
Calculated_Charges
need to be corrected.
b. If a. is true, the FORMAT() function can't
operate
on the #error result correctly.

If none of this helps, then I still may not be
seeing
the picture correctly. I'd be glad to stick with the
problem, but you might prefer to start over and seek
help
from others. Let me know what you want to do.

HJ

-----Original Message-----
Good morning to you too,
I have another query which calcultes the discount for
me,
so I'm using other queries to get values; discount
value
etc. from the query that calculates values for me..
So
the
promblem is; I can't use parameter to display certain
value specialy the discount value/s. THANKS

-----Original Message-----
Good morning!
If I read your response correctly, you have a
parameter
statement as a criterion in the calculated Discount:
field, and the Discount: calculation is drawing on
existing values for Calculated_Charges and
Adjusted_Charges.

a. If the above is true, then I don't understand
why
you want the user to input something on top of a
calculation. If you are calculating the discount,
it
shouldn't require any additional input.
b. However, if the parameter statement occurs in
another field (perhaps the Adjusted_Charges field?),
then
the statement is incorrectly phrased; " Like [...]
& "*" "
asks for text, and it appears you want the user to
input
a
number. If you want a number input the phrase
should
read
simply [Enter a Discount].

Please post back with some clarification of the
above.
I'd like to help you to a satisfactory solution.

hj


-----Original Message-----
Hi,

The field contains calculates percentage of a
discount:
and here is synt. for that field; "Discount: Format
(([Calculated_Charges]-[Adjusted_Charges])/
[Calculated_Charges],"0.###%")"
parameter; Like [Enter a Discount] & "*" .
Also I have query that I'm using for all the
queries
that
I'm using... just to avoid duplicate for all
calculated
fields; like calculatd_charges and
adjusted_charges..

-----Original Message-----
Hi,
A number of possibilities. Please post back
with
the
parameter statement as it currently exists and
explain
what you want the parameter to do.


-----Original Message-----
when I try to run query that conatains premeter
that
asks
user to enter a value, I get this error: "This
expression
is typed incorrectly, or it is too complex to be
evaluated. For example, a number expression may
contain
too many complicated elements. try simplifying
the
expression by assigning parts of the expression
to
variables"

Any idea how to solf this issue...
.

.

.

.

.

.

.

.

.

Hi,
"ooh no" yes... I mented agreeing with you what you wrote.
I'm still having the same problem.... any help I can get
will be Appreciated.... Thank you again..

-----Original Message-----
Good morning,
I hope you are operating okay now - I assume "yes" by
your last post.

Best regards, hj

-----Original Message-----
Hello,
Yes, you're right: I changed a field name after I bump
into this error. I was able to use parameter in a
different way or display a numeric data including
percentages. here is one of the fields that I used
QueryA;
Calculated_Charges: Format(([Implementation]+[Payroll]+
[Tax_Filling]+[Training]+[HR/PR_Front_End]+
[Time_Attendance]+[Self_Service]+[Resource_Hire]+
[Benefit_Services]),"Currency")
Adusted_Charges: is similar to Calculated_Charges... so
from here I use this two fields to get a percentage from
its value.

"THANKS YOU"
-----Original Message-----
Hi,
By your answer I hear you say that QueryA, which
calculates Discount:, was working before and now is not
working in some cases. In your post of data samples I
see
some values are okay and some are #error. If nothing
has
happened to the code for QueryA, and the data base has
not
been altered (no query or table or field name changes,
etc.), then I feel there must be a problem with the
data
to produce #error for some but not all instances of
Discount:.
If you would and can, please post (or pass me by
email)
a sample of QueryA output which displays
Calculated_Charges, Adjusted_Charges, and Discount:
which
includes both good and bad results.

This may take a little longer for me to get an exact
picture of your process. If you prefer we can discuss
this outside the user group by e-mail. Mine is
- without the ijk. Please
include "Access newsgroup error problem" in the subject
line.

We'll get there - hang in. I'm on Central Daylight
Time
and online 8-4:30.
Regards, Howard

-----Original Message-----
Thanks again,
All the things that you wrote is correct; however,
having
said that... it was working before, and all the seturn
db/queries started not to dispay the correct data. if
there is anything I can do to fix this problem please
help
me. I'm just new using MS Access. Thanks

-----Original Message-----
Let me see if I have the picture now:
1. You have QueryA that calculates Discount: and
formats the result as "0.###%", and you have another
QueryB that uses QueryA as a recordsource and which
contains the parameter statement asking for the user
to
select a discount value.
2. By your other post showing calculation results
(from QueryA?), some calculations return #error.

If this is the correct picture, then I think you
might
have a data problem.
a. Some values of Calculated_Charges may be =0 or
null. Calculated_Charges is a denominator and should
not
=0 or be null. Suggest you print values of
Calculated_Charges to see if this is true in cases
where
Discount: = #error. If true, values of
Calculated_Charges
need to be corrected.
b. If a. is true, the FORMAT() function can't
operate
on the #error result correctly.

If none of this helps, then I still may not be
seeing
the picture correctly. I'd be glad to stick with the
problem, but you might prefer to start over and seek
help
from others. Let me know what you want to do.

HJ

-----Original Message-----
Good morning to you too,
I have another query which calcultes the discount
for
me,
so I'm using other queries to get values; discount
value
etc. from the query that calculates values for me..
So
the
promblem is; I can't use parameter to display
certain
value specialy the discount value/s. THANKS

-----Original Message-----
Good morning!
If I read your response correctly, you have a
parameter
statement as a criterion in the calculated
Discount:
field, and the Discount: calculation is drawing on
existing values for Calculated_Charges and
Adjusted_Charges.

a. If the above is true, then I don't
understand
why
you want the user to input something on top of a
calculation. If you are calculating the discount,
it
shouldn't require any additional input.
b. However, if the parameter statement occurs
in
another field (perhaps the Adjusted_Charges
field?),
then
the statement is incorrectly phrased; " Like [...]
& "*" "
asks for text, and it appears you want the user to
input
a
number. If you want a number input the phrase
should
read
simply [Enter a Discount].

Please post back with some clarification of the
above.
I'd like to help you to a satisfactory solution.

hj


-----Original Message-----
Hi,

The field contains calculates percentage of a
discount:
and here is synt. for that field; "Discount: Format
(([Calculated_Charges]-[Adjusted_Charges])/
[Calculated_Charges],"0.###%")"
parameter; Like [Enter a Discount] & "*" .
Also I have query that I'm using for all the
queries
that
I'm using... just to avoid duplicate for all
calculated
fields; like calculatd_charges and
adjusted_charges..

-----Original Message-----
Hi,
A number of possibilities. Please post back
with
the
parameter statement as it currently exists and
explain
what you want the parameter to do.


-----Original Message-----
when I try to run query that conatains premeter
that
asks
user to enter a value, I get this error: "This
expression
is typed incorrectly, or it is too complex to be
evaluated. For example, a number expression may
contain
too many complicated elements. try simplifying
the
expression by assigning parts of the expression
to
variables"

Any idea how to solf this issue...
.

.

.

.

.

.

.

.

.

.