Re: INSERT INTO HELP

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"jamesfreddyc" <jamesfreddyc@xxxxxxxxxxx> wrote in
news:1163000500.190485.58510@xxxxxxxxxxxxxxxxxxxxxxxxxxxx:

Query1:
tDate TrapNo Species AmtColl
1/1/2000 E1 TAE 100
1/1/2000 E1 COL 150
1/1/2000 E1 TIT 205

I need to Insert these rows into another table with this setup:
tDate TrapNo TAE COL TIT
1/1/2000 E1 100 150 205


Any suggestions are greatly appreciated!

A crosstab query will create the one row from the 3, and then you
can base the INSERT on the crosstab.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

Relevant Pages

  • Re: Importing Text File that is vertically oriented
    ... > I have a MS access database into which I need to import a text ... I would ideally like to setup ... either write a crosstab query to pivot the data horizontally and ... visual basic code that manipulates the data and sets the value ...
    (comp.databases.ms-access)
  • crosstab questions
    ... Ok...I have setup a crosstab query. ... wizard. ... A report's controls need to be bound to fields. ...
    (microsoft.public.access.queries)
  • Crosstab Query
    ... I have a Crosstab query that does everything I need, ... correctly ie no page setup. ... Is there an easy way to report a crosstab query? ... Prev by Date: ...
    (microsoft.public.access.queries)