Using Query results

B

Bob Mullen

I have created a query to count the number of rounds played by a member. The
SQL View of the qryRoundsByMembers is as follows:

SELECT tblMembersGolfHistory.fldID, Count(tblMembersGolfHistory.fldID) AS
CountOffldID
FROM tblMembersGolfHistory
GROUP BY tblMembersGolfHistory.fldID;

The query works nicely. My problem is that I would like to pass the
Count(tblMembersGolfHistory.fldID) As CountOffldID value to a variable in a
form for further processing.

Can anyone tell me how to reference this. By the way I have open the query
using rst.open "qryName".

I want to assign that one value to intRounds (total number of rounds played).
 
B

Bob Mullen

Sorry to bother everyone. I discovered my problem.
intRounds=rst("CountOffldID") works just fine.

Thanks anyways
 
Top