New user

[Leigh]

I have create a number of tables with NSW info in one
Victoria in another and QLD in another.
I am trying to combine all of the data into one large
table then query NSW QLD etc from the one table
Any help would be appreciated.

 

[Van T. Dinh]

Check Access Help on Union Query. You can use the Union
Query as the Source for your Select Query.

OTOH, it sounds like you should re-structure so that the
data for different states are in one Table with a Field to
specify to which state the Record relates to.

HTH
Van T. Dinh
MVP (Access)

 

[John Vinson]

I have create a number of tables with NSW info in one
Victoria in another and QLD in another.
I am trying to combine all of the data into one large
table then query NSW QLD etc from the one table
Any help would be appreciated.

You can do this temporarily using a UNION query; or - better, IMO -
you can rename the NSW table to "Australia", add a new field STATE,
and run an Append query appending the QLD (and SWA and whatever other)
tables into it. Storing data in tablenames is never good design!

John W. Vinson[MVP]
(no longer chatting for now)