AndyDevine1
Board Regular
- Joined
- Jun 1, 2006
- Messages
- 172
Hi there
I have a table called "Current week" which contains a field called "Current week". This always contains one row of information, for this example lets say the current week is "week 20"
In my "master database" table I have an "all weeks" field and a "tag" field
In "all weeks" I have:
Row 1 = "2013 week 19"
Row 2 = "2013 week 20"
Row 3 = "2014 week 19"
Row 4 = "2014 week 20"
etc
What do I need to write an update query to update the "tag" field based on:
..if "all weeks" field contains "current week" then tag it with "yes", otherwise tag it with "no"?
ie to get...
All weeks (field)...tag (field)
Row 1 = "2013 week 19"...no
Row 2 = "2013 week 20"...yes
Row 3 = "2014 week 19"...no
Row 4 = "2014 week 20"...yes
Many thanks
I have a table called "Current week" which contains a field called "Current week". This always contains one row of information, for this example lets say the current week is "week 20"
In my "master database" table I have an "all weeks" field and a "tag" field
In "all weeks" I have:
Row 1 = "2013 week 19"
Row 2 = "2013 week 20"
Row 3 = "2014 week 19"
Row 4 = "2014 week 20"
etc
What do I need to write an update query to update the "tag" field based on:
..if "all weeks" field contains "current week" then tag it with "yes", otherwise tag it with "no"?
ie to get...
All weeks (field)...tag (field)
Row 1 = "2013 week 19"...no
Row 2 = "2013 week 20"...yes
Row 3 = "2014 week 19"...no
Row 4 = "2014 week 20"...yes
Many thanks