J
JohnM77 via AccessMonster.com
I wish for my query to display two decimal places without truncating the
original data. I've accomplished this goal by using the format function in
the query, but this function converts the numeric data to string.
Consequently, programmatically filtering a form (which displays the query)
for numerical ranges fails, due to the values no longer being numeric.
Is there a way to force two decimal places to be displayed without converting
to a non-numeric datatype?
Thanks,
John
original data. I've accomplished this goal by using the format function in
the query, but this function converts the numeric data to string.
Consequently, programmatically filtering a form (which displays the query)
for numerical ranges fails, due to the values no longer being numeric.
Is there a way to force two decimal places to be displayed without converting
to a non-numeric datatype?
Thanks,
John