Additional fields in query preview

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have designed the following query in the Access query design grid.

It deletes a record from a table with two fields. When I preview the query
results 4 fields are displayed:
fldTestRprtStdID, fldTestrprtStdRef, Field0, and Field1.

What do Field0 and Field1 represent? They appear to contain the same data as
my fields fldTestRprtStdID and fldTestrprtStdRef.


tblTestRprtStds
fldTestRprtStdID
fldTestrprtStdRef

DELETE tblTestRprtStds.*, tblTestRprtStds.fldTestRprtStdID,
tblTestRprtStds.fldTestrprtStdRefNum
FROM tblTestRprtStds
WHERE (((tblTestRprtStds.fldTestRprtStdID)=34) AND
((tblTestRprtStds.fldTestrprtStdRefNum)=3));


Cheers,
Seth
 
They are simply another copy of two fields from the SELECT *. Your query
says "show me all the fields and in addition, show me these two of the same
fields". Every column in a query must have a unique name.
 
Back
Top