Combine Queries

[access_viper]

Is there a way to combine queries? Or combine two charts into one?

Thanks.

 

[Rabbie]

Is there a way to combine queries? Or combine two charts into one?

Thanks.

Union queries may be the answer. See Access help for more info

 

[access_viper]

Union queries may be the answer. See Access help for more info

Rabbie,

May the heavens above rain down blessings on you!!!

Thank you very much, that is exactly what I needed. Here is my query via SQL statements:

SELECT [Product]
FROM [Georgia]

UNION ALL SELECT [Product]
FROM [Florida];

Works like a champ.

Thanks, again.

 

[Rabbie]

Your'e welcome! Happy to have been of help