-----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"