Update query

[goslincm]

I'm trying to run an update query that if any of my 8 fund balance fields is negative, the value in field [8Score] will update to 1, if not it updates to zero, and if any of the 8 fund balance fields has no input, no score is updated.

I don't know how to set this up.

 

[lespaul]

how is the data stored for the fund balances?

Do you have other fields name 1Score, 2Score, 3Score, etc.?





Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[goslincm]

All the score fields are numeric fields, and I have them just as you indicated: 1Score, 2Score, etc.

 

[lespaul]

have you read the Fundamentals document linked below? your table design is 'committing spreadsheet' and is not normalized...by not having normalized data queries to extract meaningful data are much more difficult to do...

If however it is not possible for you to correct your table design, then you will need to provide more details in order for someone to help you in an effective manner. If you look at Thread701-1276107 you will see how the poster "shows" the data and the expected results. If you will also provide this "picture" of what you want, helping you is a lot easier.



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi