Update Table Query with percent values

[GinaFlan]

Microsft Access 2007 I attached a sample file from the main database
The table CBA that I imported into Access came from another source. The design view properties for the table CBA are FIELD SIZE: double FORMAT: percent DECIMAL PLACES: 0 I would like to update the table SLDR with those percentage values. It does not matter if it is decimal or percent I basically just need those numbers(student scores) to be inserted into the column. I have tried several different ways setting properties and such. I either end up with 1's or 0's or it rounds the value to 100%

Any ideas on how to make this work I realized I could export the SLDR table insert the values in Excel and reimport. I was looking for a shorter way since I have to do this report every six weeks.




Thank you for any help

[June7]

This worked:

Round([Percent Score]*100, 2)

Remove Percent format from both tables. I never set formatting in tables.

Very odd. For some reason field will not take decimal even thought it is set as Double. Even Decimal does not work.

I tried creating new table and updating, still won't take decimal. Tried this data in another database. No good.

Then I tried updating records with a fixed value - 37.25 - this works. Changed query back to use the field and now I get decimals. Took closer look at data. Apparently don't need decimal part anyway, just round to whole number.

Something about the imported data.

[GinaFlan]

Ok Great Thank you

[June7]

Did some edits on my post. Might review again.