multiple tablles said:
my database possesses vary tables with the same fields, how to consult in all
at the same time
ex: ba.comutacao rj.comutacao ba.comutacao
You should reconsider this design: it is NOT good practice. Storing data in
tablenames (as you seem to be doing) makes searching much more difficult! You
should consider creating *one* table, with one additional field (perhaps for
your current table names), and running Append queries to move your data into
this one table.
If you are unable to do this, you can use a UNION query to connect all these
tables together. See UNION in the online help; you will need to build the
query in the SQL window.
John W. Vinson/MVP
