Hi guys, I have what I thought was a simple problem that is driving me mad. I have a table which includes some calculated fields. The calculated fields are really new fields that become data for the table.
I want to run a simple select query that selects records that occur in a particular geological formation (i.e. from the field GEO), and place it into a new table that contains only the records for that geological feature. I know my SELECT query SQL is correct, but it won't run because some fields are calculated fields.
I tried copying the entire table into a new table, then tried copying the calculated fields into a new field (with the idea to delete the calculated fields so i could then run my select query), but the numbers round up. So I tried adding the new field, and while blank, changing the field size to double and with two decimal places then copying. The numbers still round up. The field is set to Number every time. So i tried copying the entire field, putting it in excel, getting rid of all formatting, made sure it was a simple number format, then copied it back into the access field....but the darn number still rounds up, even when I have set the field size to double and the decimal places to two, it keeps rounding up. Even if i just type a number in the new blank field, the number still rounds up. What am I doing wrong to prevent the number rounding up? Just to repeat - the new field is set to Number, field size is double and decimal place set to two.
Is there anyway I can convert my calculated fields to a field that contains simple values, or copy that calculated field into a new field that contains simple values with the right decimal places, so I can use them in my select query?