decimal point designation in a query

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

Guest

Hi,

I am querying a field (ddlat) and would like to assign the number of decimal
points in the queried field to two, so values that are now 45.9 and 46.874673
would be 45.90 and 46.87, respectively. I thought I could do this by opening
up "field properties" for that field in the query design view. However, when
I do this nothing changes in the query. The original field in the table is
formatted to number type so this is not the problem, I think. ANy help??
 
Giz,

I think if you set the Format property of the field in the query design
to either Fixed or Standard, you will get the effect you seek.

Having said that... Generally, I would regard the query dataset as not
intended for direct human consumption, so it doesn't usually matter what
the format of the data is in the query. Normally a form or report is
where you are seeing the data, so it is in the form or report design
where I would normally be concerned to set the format I want, not in the
query.
 
Back
Top