Using Query results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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).
 
Sorry to bother everyone. I discovered my problem.
intRounds=rst("CountOffldID") works just fine.

Thanks anyways
 
Back
Top