Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: silverfish12
- Order by date
-
Rounding up formulas
Yes, I got it working by using lbass' formula. Thanks.- silverfish12
- Post #18
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Rounding up formulas
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>...- silverfish12
- Post #15
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Rounding up formulas
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...- silverfish12
- Post #11
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Replacing Table Fields w/ Another value
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...- silverfish12
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
