Output Count in OK

[seafuzz]

How do I write a Select statemet to output the couunt of records from a query in to a vbOK box. Below is the select statement I need the VBA code to make this hapen.


Select Count(Account) from [Print PCCs] as [Count of PCC]

Thanks

 

[SkipVought]

Hi,

First your Select statement is incorrect...

Select Count(Account) as [CountOfPCC] from [Print PCCs]

Second, the results are in your RecordSet object. You must assign the results of your query for the RecordSet object to a variable in order to use it.

With RecordSetObject
   .MoveFirst
   MyString = !CountOfPCC
End With

Hope this helps


Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com