Inherit table.field format in a summary query

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

Guest

I have a table with a field whose datatype is currency. I have set the format
for the field to be "General Number" in table design. When I create a summary
query based on the table this field displays in currency format. I want the
default behaviour for new queries to use the format I defined in the
table...is this possible?
I do not want to change the windows regional settings and I wish to keep the
field a currency datatype (for speed and accuracy reasons)
 
Yes, Jim, I can see that behavior. JET uses the General Number format if you
merely list the values, but as soon as you aggregate them, it displays them
as currency. It kinda makes sense: when it is displaying the actual field
values it uses the format defined for the field, but when it shows a
summation the total is not the field and so it displays the result based on
data type.

You can right-click the field in query design view, and choose Properties.
Beside the Format property for the field, choose General Number. (In
general, these field formats are not great, but it seems to work for this
case.)

Does it really matter what shows up in the query? In a form or report based
on the query, you can set the Format of the text box, and you generally
don't let your users anywhere near the actual tables and queries.

I can appreciate that there are good reasons for choosing the Currency type
for purposes other than currency, so you get the advantages of fixed-point
math.
 
You are right, it doesn't really matter but I use this field to hold number
values where a currency format does not really makes sense (the same field
also does have dollar values). I have a "query" database with read only links
to the main database where people can make their own queries and when they
see the results in $'s they question it.
I was hoping there was some hidden registry entry that might solve this for
me.
Oh well.
Thanks for your input.
 
Back
Top