Number losing decimal when moved from temp table to home table

[CBR1000f]

Good morning

I have a glitch with a query I think. I'm a user not programmer so I'm hoping for some advice.

I use transferspreadsheet to upload a report into a temp table, then a series of queries to move relevant information to appropriate tables, and a final query to empty the temp table ready for the next upload. I had a lot of help from Johnbigbooty with this functionality.

The spreadsheet layout is not optimal so I have had to make most of the fields memo fields to contain all of the information being uploaded. The problem I am having is that where the temp table contains a number such as 0.8, after the query runs the final table shows 0 (no decimal). If it says 80.0, the final table shows 80.

Here is the query:
INSERT INTO tbl_opr_workforce_professional ( application_id, workforce_professional, additional_fte_6 )
SELECT tbl_opr_temp.f30, tbl_opr_temp.F1, tbl_opr_temp.f11
FROM tbl_workforce_professional INNER JOIN tbl_opr_temp ON tbl_workforce_professional.workforce_professional = tbl_opr_temp.f28
WITH OWNERACCESS OPTION;

I thought that formating the final table as long interger with 1 decimal might solve the problem but it doesn't seem to have made any difference.

Does anyone have any thoughts about what might fix this problem?

 

[pbaldy]

If you're saying the data type is Number and the Field Size is Long Integer, that will not hold a decimal value (hence the name Integer). Try Currency, Decimal, Single or Double.

 

[CBR1000f]

Thank you Paul. Your suggestion makes perfect sense. I had a play and came up with a suitable combination (if anyone else reads this):
Field size double
Format Fixed
Decimal places 1

 

[pbaldy]

Happy to help.