SQL And Store Record Returned in Variable

[Chester]

Hello All,

I'm using MSAccess 2003. In code I want to run an SQL Query which will return 1 field with 1 record containing a number. I got the Query, which works I just need a very simple "dummy" example on how to store the number from the query in a variable!

Currently, I am using the Do.Cmd command to run my query..

Thank you for ur time and advice

 

[cjard]

VB.NETForums, "The Exclusive Visual Basic.Net Community" website is, curiously enough, a community exclusively for Visual Basic.NET programmers
This particular forum is for interacting with an Access (JET) database through VB.NET

Given that Do.Cmd is an Access internal function, I would surmise that you are using Access (as an IDE), not Visual Basic.NET.. If this is correct, then I think the possible help you will find here will be limited, as its not really our skillset.

 

[Chester]

Oh sorry..barking up the wrong tree i'll try somewhere else