S
Susan R
I have several queries for which I am trying to format the field to number
(specifically "Fixed). The underlying table fields are properly formatted
but when I try to format the query fields through field properties, the
format selection box in blank. I tried manually entering the word "Fixed"
but, of course, that did not help. The format issue is causing two problems:
1. My expression results are displaying infinate places to the right of the
decimal point.
2. When I try to run reports based on these queries, and sum the detail, I
get a data type mismatch. Also, I can not format the report results through
properties because the format selection is also blank there.
Please help.
(specifically "Fixed). The underlying table fields are properly formatted
but when I try to format the query fields through field properties, the
format selection box in blank. I tried manually entering the word "Fixed"
but, of course, that did not help. The format issue is causing two problems:
1. My expression results are displaying infinate places to the right of the
decimal point.
2. When I try to run reports based on these queries, and sum the detail, I
get a data type mismatch. Also, I can not format the report results through
properties because the format selection is also blank there.
Please help.