I am new to Microsoft Access but am familiar with SQL in general (i.e. used Informix Sql).

Is it possible to execute multiple statements in Access? (I assumed that this was standard but can't seem to do it.)

Eg. Simple Example

select * from tab1;
select * from tab2;

The above 2 instructions will not run with the error "Characters found after end of SQL statement".

Any help appreciated!
Thanks !