Write a small Microsoft Access VBA routine

I have a very small project - i need a small snippet of code to add to my Microsoft Access database. I have attached the db with the table. It is a pricing file for an item master. the SEQ number is the item number and for each SEQ number there are 5 vendor prices. The table will remain in this design, so what i need is the VBA routine to tell me the lowest price of the 5 prices for each item. The code would then update the LP field with the lowest price.