Output of Queries

  • Thread starter Thread starter David A
  • Start date Start date
D

David A

HI

I would like to know how to; output one query to several
tables otherwords all the Type A records make table in A
and all type B go to make table B. Type is a variable
I am not a programmer in VB so be simple if you can

Thanks Much
david A
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You don't need to use VB to create these queries.

You will have to create 2 Make-Table queries: one for Type A the
other for Type B. The reason you have to create 2 queries is each
query will have a different table destination. That table destination
has to be "hard-coded" into the query.

Open a new query in design view.
On the menu bar select Query > Make Table Query.
In the Make New Table dialog box enter the name of the new table.
Then set up the query to select data from the original table for the
new table.

HTH,

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQBV38oechKqOuFEgEQKiXgCgtcpB8zjMmrKSk2w//sIsvbJoq8gAnRH2
aT3xGNdldw/RqUGsHCNodwli
=caZO
-----END PGP SIGNATURE-----
 
Back
Top