Making a field equal the other

[davewaltonuk]

Hi there

I have quite a long winded complex database

i have performed queries to calculate points and i would like the query to store the points back in the table

ie
field 1 field 2 field 3
11 55 0
12 666 0
13 764 0
14 54 0

should read
field 1 field 2 field 3
11 55 55
12 666 666
13 764 764
14 54 54

I woiuld of thought it would be as simple as putting in the criteria of field 3 =[field2], however this produces blank values

can anyone help i have attached 3 pictures of my problem

 

[stormin_norm]

In the design view the criteria section is your "where" clause in sql. So you would be looking for records where field3=field2, hence NO records.

What you want:

In design view in FIELD you want the following

Field: Number 1ST HALF TOTAL field3: 1ST HALF TOTAL
Table: team Half 1 Points team

Or am I missing something?
Why return the same info twice??
And why is GK Half 1 in both tables?

-norm.

 

[AncientOne]

You need to run an !UPDATE QUERY not a select query. But as stormin said, why bother, if it's already in another column? Doesn't make sense!