Additional fields in query preview

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
 
D

Duane Hookom

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Duplicates with a Delete Query 3
IIF Function Within A Query 6
Syntax error in query expression 2
Criteria - show records in text field1 based on a yes/no field2 7
Query shows all fields... 3
sum two seprate fields in query 4
Make table query with derived fields 1
Query Field Using Other Fields in the Query 3

Top