Hi
Can anyone tell me if its possible to create an Access Query and then put one of the fields returned in that query into an Integer variable ?
i want to say something like:
SELECT x,y,z
FROM X,Y,Z
WHERE blah blah & blah;
and then in VB code something like:
Dim CounterVariable As Integer
IF x = 3
THEN CounterVariable = 3
& bring up report3
IF x = 4
THEN CounterVariable = 4
& bring up report 4
etc (for 6 variables)
what is the syntax for saying this in vb???
any help wouldbe appreciated
Can anyone tell me if its possible to create an Access Query and then put one of the fields returned in that query into an Integer variable ?
i want to say something like:
SELECT x,y,z
FROM X,Y,Z
WHERE blah blah & blah;
and then in VB code something like:
Dim CounterVariable As Integer
IF x = 3
THEN CounterVariable = 3
& bring up report3
IF x = 4
THEN CounterVariable = 4
& bring up report 4
etc (for 6 variables)
what is the syntax for saying this in vb???
any help wouldbe appreciated