SELECT query error

I get the following error 'number of query values and destination fields not
the same' on the second line of the following code. I'm using D6 with
MSAccess 2000. What is the cause of this? I can replace with ... SELECT
Temp.TOTALTIME, Temp.DONE, Temp.Status .... and it works OK.

INSERT INTO Temp ( TOTALTIME, DONE, Status )
SELECT Temp( TOTALTIME, DONE, Status )
FROM Temp
WHERE ((Temp.DONE)= True);


.

Relevant Pages

  • Re: Informix vs Oracle vs DB2. SQL Query optimization.
    ... but I think you're confused because you don't know Oracle. ... the query chooses to limit TAB_A by the col_id. ... initially we have the collection as geo1. ... case of 270,000 rows in the collection, and 60,000 rows in the temp ...
    (comp.databases.informix)
  • Re: Relationships, back end
    ... query the same, using the linked file directly rather than a temp table. ... |> into tblMovements but into a temp table, ... | adds the EquipmentID field the the temp table". ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Include Function in Sort
    ... Okay, ... Now if I use TotalTime as the record source for my text field, I Get Exactly The Result I Want! ... until I sort? ... If it is a field in the query, you need to pass it to the ...
    (microsoft.public.access.formscoding)
  • Re: Multi column update
    ... The example I've given is a sort of simplified version of my query, ... limited by how fast the server is able to write the redo information. ... temp table, and then reference that temp table with your update query: ... will be written to the trace file. ...
    (comp.databases.oracle.misc)
  • Re: Writing a query using VBA - Variable where clause
    ... that collection and set its member to true for member items IN the "temp" ... 2- Make an ad hoc query from a string. ...
    (microsoft.public.access.queries)