-
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
-
Boyd Trimmell aka HiTech Coach
Microsoft MVP - Access Expert
[SIGPIC][/SIGPIC]
Office Programming 25+ years as a Software Developer specializing in:
Business Process Management
Accounting/Inventory Control
Customer Relations Management (CRM)
Electronic Data Interchange (EDI)
-
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.
Boyd Trimmell aka HiTech Coach
Microsoft MVP - Access Expert
[SIGPIC][/SIGPIC]
Office Programming 25+ years as a Software Developer specializing in:
Business Process Management
Accounting/Inventory Control
Customer Relations Management (CRM)
Electronic Data Interchange (EDI)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|