Board index Office Access

using query to change Value in field depend on another field value

using query to change Value in field depend on another field value

Post by 1aae » Fri, 14 May 2004 23:45:57


Thank you
This is example:
Serial PName field1 Field2
1 ahd 100 10
2 sdf 100 12
3 sdfsd 100 13
4 sdf 100 14
5 asd 100 10
What I want
If you Find (2 or 3 or 4 or ) in (Field2) the (same value) here in my
example (10) give them the same value of the First (Serial) Value where
condition is field1 = 100
My example will be
Serial PName field1 Field2
1 ahd 100 10
2 sdf 100 12
3 sdfsd 100 13
4 sdf 100 14
1 asd 100 10
this Is what I want:
More information if you need to sort I will need to sort PName..
 
 
 
Top

using query to change Value in field depend on another field value

Post by Michel Wal » Sat, 15 May 2004 23:47:32

Hi,



UPDATE tableName
SET Serial= DMIN('Serial', 'tableName', 'Field2=' & Field2 )


(make a backup first, or test on dummy data before applying it on real
data).

Hoping it may help,
Vanderghast, Access MVP

 
 
 
Top

1. How to suppress printing a value in a field depending on the value in another field.

2. changing field in select depending upon other field value

3. how to change value of field B if its initial value is fr field A

4. [XML Schema] Value of a field depending to other fields?

5. Value of a field depending to other fields?

6. Form Validation where 1 field depends on another fields value

7. Field displays depending on another table field value

8. Value lists that depend on the value of a previous field

9. Adding a field whose value DEPENDS on other fields in table

10. Does a field value equal another field value problem

11. Display a value in a field based on the value of 2 other field

12. Value in a field sets the value of another field

13. Assigning a value to a field based on other fields value

14. Field default value = value of AutoNumber field?

15. find max value in one field, return values in other fields in same row

All times are UTC
Board index