decimal places

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

Guest

My apolgies if this is entered twice, not sure if i did it the first time.

I need to format numbers in field1 according to the value of field2

ie if field1 is 12.0433 and field2 is 7, then i need to see displayed
12.0433000,
and if field1 is 12.0433, and field2 is 2, then i need to see displayed 12.04

any ideas greatfully received

pat
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2 options based on result 4
updated field 3
Error message - unique index created on two different fields 3
IIF / OR condition (can OR be used)? 2
Report layout problem 2
Maximum value from table 9
Programmatically Set Text Box Control Source On Form Load 7
Create and Open Word Document From Access & asociate with 2 Fields 3

Back
Top