asked on

Copy a calculated query value to a field in table

Hello, I have a query where I calculate a few values using IIf statements. I want to take the results of this calculation and copy them to a field in the underlying table (this field is also in the query). How would I go about doing this (Calcfield: IIf(statement) to DestinationField both in the same query).

Thanks,
Bevo

ASKER CERTIFIED SOLUTION

Jim Dettman (EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

peter57r

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Bevos

ASKER

Hi Peter and JDettman, thanks for the informative responses. I think I understand what you are saying with the update query, but I have a question. Should I wait until all the data is entered for this project to run the update query and copy over the IIf statements to the table fields?

Thanks,
Bevo

SOLUTION

Jim Dettman (EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Bevos

ASKER

Hi, sorry to be vague. Basically this will be copied into a table that is ultimately exported as a CSV for import into a reference manager called End Note. I only really need this as an end product so it isn't too much of a worry just to do this once at the end I believe.

I think I have everything I need now so I'm going to close the question.

Thanks for all of the great comments,
Bevo