Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Access Training and help » Counting field values
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Counting field values
Resolved · Low Priority · Version 2003
Reply
Counting field values
I am trying to design my database and let's say I have 8 number fileds (each decimal double) to enter the number of vaccines administered to people in different age groups (8 categories) on my form. And I want to create settings that would allow user to enter only correct data - in this case the sum of those eight fileds should match and fit the total number, which is another number field with called ' total number of vaccines administered'. How to set it up? Is it something to do in table properties? Is it validation rule or is it expression builder where I do the settings? I am looking forward for your help.Thanks in advance
For upcoming training course dates see: Pricing & availability
RE: counting field values
Hi DaigaThanks for your question
Can you clarify for me how you want this to work?
Do you want the user to enter the 8 numbers, and after the final number is entered Access checks to see if the sum of the numbers matches a figure in the totals column?
If this is the case, then what do you want to happen if the numbers don't match?
Thanks
Stephen
RE: counting field values
Yes, there should be 8 number fileds on the form, but I would like to have another one - N/A (when data is not provided). If data are provided for only some age ranges, I should assume the rest are zero. N/A only to be used if no data provided at all (so should be left blank the field of totals aswell). Yes, I think that would be the best - that Access checks whether the totals column matches with sum after all fields antered. If they don't match I would like to have the message popping up that the sum of hose 8 fields should be equal to totals. Perhaps there is a way to set up each field that it is not greater than total field. .....
Counting field values
Yes, there should be 8 number fileds on the form, but I would like to have another one - N/A (when data is not provided). If data are provided for only some age ranges, I should assume the rest are zero. N/A only to be used if no data provided at all (so should be left blank the field of totals aswell). Yes, I think that would be the best - that Access checks whether the totals column matches with sum after all fields antered. If they don't match I would like to have the message popping up that the sum of hose 8 fields should be equal to totals. Perhaps there is a way to set up each field that it is not greater than total field. .....
|
 |
Empowering Your Meetings With PowerPoint Do you make the mistake of letting PowerPoint do all your work for you? It's not an autocue - it's a presentation tool, so do you know how to get the best out of it? Here are some tips for clearer, more dynamic presentations with Powerpoint. » Article: Powerpoint courses london |
» Forum post: Moving between different workbooks |
I want to get data from a series of workbooks (which I don't want to name) and enter the data into my workbook. What code will I need.
