G Guest Jan 4, 2006 #1 I want to multiply [text56]*103%. i cnt semm to get the answer I need. Its on a report. Help!
G Guest Jan 4, 2006 #2 What are the values in text56 and what are you getting versus what you expect? Have you formatted the results as a percent? That could change the way things look. Something like this might work: Format([text56] * 1.03/100,"Percent") Is text56 a text field or number field? Multiplying by a text value can be somewhat iffy even if the characters are numerals.
What are the values in text56 and what are you getting versus what you expect? Have you formatted the results as a percent? That could change the way things look. Something like this might work: Format([text56] * 1.03/100,"Percent") Is text56 a text field or number field? Multiplying by a text value can be somewhat iffy even if the characters are numerals.
J John Vinson Jan 4, 2006 #3 I want to multiply [text56]*103%. i cnt semm to get the answer I need. Its on a report. Help! Click to expand... Multiply [Text56]*1.03 John W. Vinson[MVP]
I want to multiply [text56]*103%. i cnt semm to get the answer I need. Its on a report. Help! Click to expand... Multiply [Text56]*1.03 John W. Vinson[MVP]
