using calculated fields in a select query involving "INTO"

[deso]

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?

[June7]

Are you using Access 2010? Your profile shows Access 2007. Access 2007 does not have calculated field type.

I haven't used calculated fields yet. Will have to experiment later and see if I can replicate your issue.

[deso]

Thanks for your help. I've actually figured it out, using excel....i wasn't correctly assigning field size prior to copy/paste.

however, it would be good to know how to do queries with calculated fields as i had to make new fields and detele the calculated field, which probably isn't ideal.

i upgraded to 2010 a few months back. I will update my profile.

Cheers

[June7]

Do SELECT queries on tables with calculated fields same as any table. The issue may be with copying the record to another table. Why would you need to do that?