I am trying, through ADO to count the number of items in some tables.
The query is the following:

```
select count(*) as a from TABLE1;
select count(*) as b from TABLE2;

```

If I run it through my SQL GUI, I get:

```
a
------------
1
b
------------
0

```

so far so good.

But, if I run this code (VBA):

```
Dim adoCon As New ADODB.Connection
Dim adoRecords As ADODB.Recordset
Dim query As String
query ="select count(*) as a from TABLE1;select count(*) as b from TABLE2;"
adoRecords = adoCon.Execute(query)
Debug.Print(adoRecords!a)
Debug.Print(adoRecords!b)

```

It fails on `adoRecords!b` If I check the adoRecords object, the Fields field only has one item, a.

If I run it in two separate queries, it works fine (but I have a important round trip time, so that's bothering...).

How could I get two outputs through ADO?

Thanks a lot for your help,

Maxime