I have been putzing around with this for a bit and can't seem to figure it out. I have a table (tblStudent) that has two fields (Range, Amt). The range records are 1-5,6-10,11-20,21-50, >50. Amt are 0 by default.

four more Tables (tblPA,tblNY,tblNJ,tbMD) with 2 fields (pctgStud,amount) where prctgStud are ranges (0, 1-10,11-25,26-50,51-100). Amount are 0 by default.


My form has a 5 simple comboBoxes that allows one of the ranges to be selected for each of them. I want to increment the amt fields of the corresponding table on click of the submit Button.

I have drawn a complete blank.Any help is greatly appreciated

Unfortunately, you have a design flaw in the tables that makes this harder than need be, but I'm afraid I don't really understand why you're trying to do this in the first place. What business rule are you trying to implement? Knowing that will help figure out how to restructure the tables and how to design an interface to support your workflow.

thanks for the reply, pretty much there are 500 word documents that have check box for how many students and then the states by percentage the students are from. Each document will have one selection for students, pa, ny, nj, & md.

I pretty much need to tally all of them and figured it would be much easier todo it within a database or vb... so far hasn't been the case but it is less aggrevating then flipping through 500 pages 5 times each.

Let me see if I understand.

Each Word document represents one "entity"--perhaps a school?
On this Word doc there is a "check box" for the number of students in the school? How does a check box indicate a number? Check boxes are either checked or unchecked, aren't they?
On this Word doc there "check boxes" for the percentage of students from each of four states? How does THAT work? Again, a check box is either checked or unchecked, isn't it?

Is this a one-time task, or will you need to keep this data and update it from time to time?

each word doc has lets call it 2 graphs...
onehas 2 rows of boxes

Estimated number of students per week considered historically


0 1-5 6-10 11-15 16 - 20 21-25 > 25

X




0% 1 - 10% 11 – 25% 26 – 50% 51 – 100%

Pennsylvania X
X
New York
X
New Jersey
X
Maryland
X
Virginia

In the end I need to count the nunumber of times pennsylvania accounted for 0% of the students and how many times pa counted 1-10% and so on

Okay, the Word doc illustrates the data well enough to make a start.

I'm sure there is additional information in play, but six basic tables will handle the requirement as far as you've shown us, . As I suggested, each Word document represents results from one "Entity". I guessed school, the Word doc implies some other sort of government agency, by referring to "caseloads". I'll think of it as a school since you've used the term student.

In any case, here's a sample of what the basic tables should look like, along with a form to do the data entry.

 CaseLoads.zip ( 49.2K ) Number of downloads: 3


George

above and beyond!!

thanks George!!

We're always glad to help. Post back if you have further questions.

COntinued success with your project.