Update query

[mwb]

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

 

[llkhoutx]

Get the count of the table (using DAO, ADO or a recordsetclcone) and then generate the half (in your query) using that count and the current ID.

 

[mwb]

I'm not so familiar with this. Is it possible for you to explain a little bit more.