Query to update only not null spaces

[Thantos Hess]

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

[HiTechCoach]

See if this demo helps:

Spreadsheet-like Entry Data Form Demo

[Thantos Hess]

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,

[HiTechCoach]

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.