How can i update so many diff results?

[Rabbie]

The truth is that i did not see the post 12.

I Lost 2 hours of my life making the code.

The simplest solution is this:

FP: IIf([Final_HomeTeamScore]>[Final_AwayTeamScore];"1";IIf([Final_HomeTeamScore]=[Final_AwayTeamScore];"X";IIf([Final_HomeTeamScore]<[Final_AwayTeamScore];"2")))

Anyway...

Have a nice day.

If you cannot be bothered to read the posts with solutions to yur problems why should anyone bother to post any solutions for you

 

[editolis]

Actually I check again the table data and find out that my code is working better because I have ONLY – ALL the final scores.
I do not have all the Final_HomeTeamScores or Final_AwayTeamScore. Many fields are empty.
So my work is worth the time I spend.
BRIAN I have already made the score field’s numeric to my new table.
RABBIE probably you did not understand. I Said I did not see the post12. I miss the point. I did not say that I never read them.

 

[Brianwarnock]

Actually I check again the table data and find out that my code is working better because I have ONLY – ALL the final scores.
QUOTE]

I don't understand this as I thought the final scores were derived from the other 2 columns, but I think will leave this now

Brian

 

[editolis]

Actually I check again the table data and find out that my code is working better because I have ONLY – ALL the final scores.
QUOTE]

I don't understand this as I thought the final scores were derived from the other 2 columns, but I think will leave this now

Brian

My data are from 3 diff tables. Old data from 2003. Also are from XML Files. New Data after 2008.

All the tables they do not have the same structure. Only the XML files have all the data.

I Have for sure the Team names and the Final score.

That's why finally my code is done the job.