G
Guest
Several times while working on my database projects I have wanted to pull a
specific bit of information from the database. For example, it might be a
customer's unique integer identifier based on some other bit of information
(the job id for example). The only way I know how to do this is to create a
recordset, make an SQL statement, execute the SQL against the database and
the get the value from the recordset. This seemed a bit extreme since I knew
I was only going to get one record and from it only need one value. So I was
just wondering if there was something I didn't know (oh who are we kidding??
There's lot's of stuff I don't know about Access!) that would allow you to
retrieve just the one bit of info you needed without creating a recordset.
Something like setting the results of an SQL statement to a variable. Thanks.
specific bit of information from the database. For example, it might be a
customer's unique integer identifier based on some other bit of information
(the job id for example). The only way I know how to do this is to create a
recordset, make an SQL statement, execute the SQL against the database and
the get the value from the recordset. This seemed a bit extreme since I knew
I was only going to get one record and from it only need one value. So I was
just wondering if there was something I didn't know (oh who are we kidding??
There's lot's of stuff I don't know about Access!) that would allow you to
retrieve just the one bit of info you needed without creating a recordset.
Something like setting the results of an SQL statement to a variable. Thanks.