Field value contains "#Error"

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

Guest

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,
A number of possibilities. Please post back with the
parameter statement as it currently exists and explain
what you want the parameter to do.
 
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..
 
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.


.
Click to expand...
.
Click to expand...
 
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...
.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
And this is the output I'm getting from the query that
calculates values for me: Colm. Values ->
Discount
#Error
#Error
#Error
#Error
33.333%
43.024%
#Error
#Error
-----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...
.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
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...
.

.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
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
Click to expand...
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...
.

.

.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
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
(e-mail address removed) - 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...
.

.

.

.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
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
(e-mail address removed) - 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...
.

.

.

.

.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
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
(e-mail address removed) - 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...
.

.

.

.

.

.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
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
(e-mail address removed) - 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...
.

.

.

.

.

.

.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Back
Top