Access 2000 - Query

[HIM]

I need to be able to access a queryresult in Visual Basic. The purpose is to update one field with the values of others. In this case it has to be done by code, because an update query is useless in this case (trust me).<br>Please help!!!! I am desperate

 

[rbowes]

Give me an example of what your trying to do.&nbsp;&nbsp;I think you might just have to do a concatenation of fields or do a calculation with VBA

 

[HIM]

Match - Table<br>ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Autonum<br>Number&nbsp;&nbsp;&nbsp;number<br>Time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Date/Time (short time) - time for match<br>Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Number - date for match<br>ETime&nbsp;&nbsp;&nbsp;&nbsp;Date/Time (short time) - ekstra time after match<br>KampNavn Number<br><br>TurnDate - Table<br>ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Autonum<br>Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Date/Time (short date)<br>STime&nbsp;&nbsp;&nbsp;&nbsp;Date/Time (short time) - time for fist mact on date<br><br>MatchName - Table<br>ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Autonum<br>HalfTime Date/Time (short time) - duration of half<br>TimeB&nbsp;&nbsp;&nbsp;&nbsp;Date/Time (short time) - time between halves<br>TimeA&nbsp;&nbsp;&nbsp;&nbsp;Date/Time (short time) - time after macth<br><br>Query<br>TurnDate.Date&nbsp;&nbsp;&nbsp;Asc<br>Match.Number&nbsp;&nbsp;&nbsp;&nbsp;Asc<br>Match.Time<br>Match.ETime<br>TurnDate.STime<br>MatchName.HalfTime<br>MatchName.TimeB<br>MatchName.TimeA<br><br>Now, I want to calculate Match.Time for every date, by adding all the time fields, but the first macth should have Match.Time=TurnDate.STime, the next should be STime+HalfTime*2+timeB+timeA+ETime. But of course these parameters should be those of the first match.<br>Any suggestions?