Changing records into fields

[Alex Reed]

Hi,

I'm trying to change a table that is structured as follows:

TagName PropName PropValue <== Field Names
Tank1 HiAlarm 100
Tank1 LoAlarm 10
Tank1 Level 55
Tank2 HiAlarm 95
Tank2 LoAlarm 10
Tank2 Level 36

It has to be changed to the following structure:

TagName HiAlarm LoAlarm Level <== Field Names
Tank1 100 10 55
Tank2 95 10 36

What is the best way of doing this using
either a query or VBA? (Access97 by the way)

I have gotten as far as creating the new table with
the correct field names, but I can't figure out how
put the data into it.

Thanks,

Alex