Hello all, need some help...
In Access 2K I'm trying to run mulitple SELECT queries, for instance I want to run the following:
select count(*) as OOB11
from [OOB Station1] where [Line]='1' and [Shift]='1'
go
select count(*) as OOB2
from [OOB Staion2] where [Line='2' and [Shift]='1'
It works in SQL Server 7, so whats the deal, does Access not support keyword 'go' or am I missing something?
Thanks for the help
Dodge
In Access 2K I'm trying to run mulitple SELECT queries, for instance I want to run the following:
select count(*) as OOB11
from [OOB Station1] where [Line]='1' and [Shift]='1'
go
select count(*) as OOB2
from [OOB Staion2] where [Line='2' and [Shift]='1'
It works in SQL Server 7, so whats the deal, does Access not support keyword 'go' or am I missing something?
Thanks for the help
Dodge