Trim text field to the dot

[teqtaq]

Hi!
If I have a text field (in my query) that is a result of the division and displaying as (example 10/3=) 3.3333333333333
how do I trim it on Report level so it displays without decimals just 3?

 

[teqtaq]

I am searching for help and I see there is suggestion of Instr([Field],",")
and
Returns a Variant (String) containing a specified number of characters from a string.
Syntax
Mid(string, start[, length])


I do not have a specified number of the characters, I need all after the dot to the left. Thanks

 

[PWise]

format(10/3,"0")
or
int(10/3)

 

[dhookom]

Why not simply set the Format or Decimal Places properties of the text box in the report. I don't think you want to do anything to the actual value, just change the display.

Duane
Hook'D on Access
MS Access MVP

 

[teqtaq]

pwise, I'll try that! Thanks

dhookom,
believe it or not - in Format - there is no items on the menu. So no items in a Format of the table's field.

I thought it could be a result of append into the the table which is actually just 1 row! Weird...

 

[dhookom]

You stated "text field (in my query)". Is this truly a text field or is it a numeric field? If it is text, why not use a numeric?

If you are using a text/string rather than a number, I would change the text to a numeric value in the report's record source query.

Duane
Hook'D on Access
MS Access MVP

 

[teqtaq]

I did changed all to Numbers in table where I am appending values. Thanks