Access & output parameters

Using VB6 & Access 2000


Can anyone tell me how I can get the result of the
query below into a variable.

PriCmd.CommandText = "SELECT MAX(Pnum) AS MaxPage FROM PInfo"
PriCmd.Execute

I have tried creating MaxPage as a parameter but it won't
seem to let me specify it as an output parameter

I know if a recordset was being returned I could do:-

set rs = PriCmd.Execute

But what do I do when just a value is being returned.

Thanks in advance

SeanR

Many thanks for your help, it did the trick

SeanR