Capturing Calculated data in a form

[brucle]

I have a form that is going to be used as a performance scorecard. To that end, I have several calculated values (from Dlookups) expressed on the form as percentages, as well as several values expressed as fixed numbers. I need to capture all these figures to a history table as the underlying data is purged after 90 days. This makes it a tad difficult giving a yearly performance figure and comparing it year to year.
The issue is that I can successfully capture the data from the fixed numbers, but the percentage values come up as either 0% or 100% regardless of the value in the text box.
The appropriate fields in the table are formatted as percentages, as are the fields in the underlying query to the form. I suspect that I have incorrect formatting somewhere. Do I need the percentage formatting everywhere or not? Management needs the formatting on the form, but I am not sure about the rest.
Can anyone offer suggestions?

 

[Rich]

Change the Data type from integer to Double or single

 

[boblarson]

And set your formatting where you want it displayed, not in the table. Just store the raw data in the table.

 

[brucle]

Thank you, Thank you very much!

Worked like a charm- go buy yourself a bottle of good wine and put it on my tab!

 

[Rich]

That's an offer not to be sneezed at