decimal places with dlookup

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

Guest

hi
i got this query with a dlookup formula. in the form try to define the
number of decimal places, but it doesn't work. i define the decimal places,
but i keep geting them on the form. the dlookup is a calculation coming from
a diferent query, i also define the number of decimal places, but still
geting them.
does anyone know how to deal with this problem?

thanks??
 
Roy said:
i got this query with a dlookup formula. in the form try to define the
number of decimal places, but it doesn't work. i define the decimal places,
but i keep geting them on the form. the dlookup is a calculation coming from
a diferent query, i also define the number of decimal places, but still
geting them.
Click to expand...

Most likely, the query has interpreted the DLookup result as
a text value.

You didn't say what type of value it is supposed to be, but
you should try explicitly converting it in the query. For
example, if the value is a currency, use CCur(DLookup(...))
 
Back
Top