Copying the values of a field that contains a function

[suzie_q]

Hello there

I have a field in a query that that contains a function to calculate the cumulative value of another field. How do I copy the actual calculated values to another table as opposed to the function?

Thanks

Suzie

 

[ColinEssex]

Hi Suzie

When you say "copy" - do you mean append to a table or update an existing value in the table.

Have you tried the append or update queries yet?

Col

 

[suzie_q]

Hi Col

I need to use the calculated cumulative values to create a chart... The chart wizard does not like the fact that the field contains a function... If I can create a new table and put the actual values in then my problems are over! I'll try the update and append queries now.

thanks

suzie

 

[ColinEssex]

Suzie

You may need to use a MakeTable query then as its going to be overwritten every time you run it. Yes?

Col

 

[suzie_q]

Col

Hooray! The createtable query worked! Thanks for the help

Suzie