Hello,

I am just recently started using Access and ran into a problem that I hope someone here could help me with. I am trying to create a form that has a basic matrix or spreadsheet look. It would have a list of people on the left side and on the top prizes. What I would like to do is to be able to input a value into each square and run a query that will update into a table a record for only those boxes with a value. Example:

------- Bike ------basket ------ gift card
Suzie______________4___________8
Sara____10_________5___________6
John____9
Karen_________________________10


This query would add seven new records in the table. The table would consist of an ID, Person, Prize, Bid

Thanks in advance for any assistance