dgillz,
It is a number field but I need to concatenate it with another field, so, I need to use the formula field to do this & I can't right click to format it.
GMcNamara,
I tried ToText({Table.NumberField}, '', 0) and I've got this error:
Error in formula <Test>...
I know this is a bit off from the original message.
I used the Round function for my field (the value is 2003, data type is integer) & in the report, it came out as 2,003.00.
I want it to be displayed as 2003 without the comma & precision. I've tried all the functions: Int(), CStr() but it still...
I'm using Access 2000. I'm using a subform linking to a mainform. In this subform, the fields are from a table called called tbl_prodpromo. In this table, there's a field - PromoAutoID (it's the primary key of tbl_promo). I would like to get the max(PromoAutoID) from tbl_promo & then insert this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.