By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,109 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

format query expression from dialog as percent

P: n/a
I am trying to format a query expression drawn from a dialog box as
percent.

The original statement to get the value for the query is as follows:

New%markup: [Forms]![Dialog Form]![NewMarkup]

The dialog box looks the values up from a table called NewMarkup. It
appears in the dialog box with a percent format. However, when I try
to call that value in my query it shows it as a decimal.

There is no option to format the field as currency.

I tried Format([Forms]![Dialog Form]![NewMarkup], "0.00%") and I get
the following error when executing...

"The expression is typed incorrectly, or it is too complex to be
evaluated. For example, a numeric expression may contain too many
complicated elements. Try simplifying the expression by assigning
parts of the expression to variables"

Please help.

Thanks!!
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Not quite sure what you want, but...

Format([Forms]![Dialog Form]![NewMarkup], "Percent")

will display the value in NewMarkup as a percent, as long as the value
in NewMarkup is a "correct" decimal value.

I hope you know that percent numbers are stored in tables as decimal
numbers. I.e.: 100% is stored as 1.00; 50.25% is stored as 0.5025;
etc. Therefore, to select records using a "percent" criteria you'd have
to indicate the percent value criteria as a decimal value. E.g.,
looking for records w/ 25%:

SELECT *
FROM table_name
WHERE Percent_Column = 0.25

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQSEqJYechKqOuFEgEQLe8wCgoH1QrAUjjPWoWsa6E9+0PY zxvrcAnA5G
TN6/pn1ghFjEnlUQ47eiL94X
=SW0s
-----END PGP SIGNATURE-----
Terencetrent wrote:
I am trying to format a query expression drawn from a dialog box as
percent.

The original statement to get the value for the query is as follows:

New%markup: [Forms]![Dialog Form]![NewMarkup]

The dialog box looks the values up from a table called NewMarkup. It
appears in the dialog box with a percent format. However, when I try
to call that value in my query it shows it as a decimal.

There is no option to format the field as currency.

I tried Format([Forms]![Dialog Form]![NewMarkup], "0.00%") and I get
the following error when executing...

"The expression is typed incorrectly, or it is too complex to be
evaluated. For example, a numeric expression may contain too many
complicated elements. Try simplifying the expression by assigning
parts of the expression to variables"


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.