Solved: Help with replacing data

[EricM]

I am currently using the following statement

Insert into hm (TestName, Folder, Alive, Dead, Average) VALUES ('%TestName%', '%Folder%', '%AliveRatio%','%DeadRatio%','%AverageReply%')

Instead of Inserting a new record I would like to replace the record where
Value (%testname%) is equal to hm (TestName).

is this possible

[Norie]

Why not just use an Update query?

[EricM]

cause I am not good at queries :-) Not sure how to write it

[EricM]

Ok
I got it to accept the update query but I have one more problem. It wont add a record if it does not exist. So I would have to make sure all possible TestName would have to be in the table already. Is there a way to have a if does not exist insert else update.

All in the same query

[geekgirlau]

You would have to do two queries: one to update the record if it exists, and the other to insert the record if it doesn't exist.