Hello and thanks for a very good forum.
I have a tbl where I haver several fields, but I want to update the heat field with a query.
Say that I want to have the first 50% set to 1 and second 50% set to 2. Anyone who can give me a hint.
Hope you can help me.
Example
ID Heat StartNo
1 101
2 103
3 104
4 107
5 110
Should be after query
ID Heat StartNo
1 1 101
2 1 103
3 1 104
4 2 107
5 2 110
I have a tbl where I haver several fields, but I want to update the heat field with a query.
Say that I want to have the first 50% set to 1 and second 50% set to 2. Anyone who can give me a hint.
Hope you can help me.
Example
ID Heat StartNo
1 101
2 103
3 104
4 107
5 110
Should be after query
ID Heat StartNo
1 1 101
2 1 103
3 1 104
4 2 107
5 2 110