Query to update only not null spaces

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

See if this demo helps:

Spreadsheet-like Entry Data Form Demo

HiTechCoach,

That is great, although I am still having some trouble switching it over to where you can put in a numerical value. So for that database, it would be like you wanted to enter the number of hours that were attended instead of just a check mark.

Thanks again,

With enough time and effort (and probably money) you should be able to do what you want.

I have never attempted this since it is so costly in time/money compared to other options. I have not been able to justify the expense to my clients.

I will be glad to take a look at what you have done so far and see if I can give you any pointers. A fresh set of eyes may help.

When posting a sample of your database, be sure to remove any confidential data.