Fetch value returned from query in vba
Posted on 2004-03-29
I have a query that only returns one field, one record. The record returned is a numeric score from a static table which acts as a scoresheet. All I need to know how to do is to get the returned record from the query using vba so I can then paste this number into a field in one of my tables. Without getting into too much detail, what happens is this, I have a table with number of situps and age groups as fields. I supply the number of situps and the age of the person, and the query shows me a score. I need to take that score and update another table with it. I want to do all of this using vba. Below is a little more description
I have a table that stores scores for sit up repetitions based on age.. here is what it looks like....
Repetitions age 18-22 age 23-26 age 27-32
30 10 9 7
31 10 10 7 <-----this number is the score for repetitions done
32 11 10 8
33 12 11 9
When I type in 31, I want the vba to grab the person's age (i know how to do this part), and put thier score into a field of another table. If I knew how to make a string using query results I could do this on my own, but I have no idea how to access query results using vba.
please excuse my sloppiness, i'm finishing up this question right before I pass out for the night ;)