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
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