Expr1003 appears instead of field name

[Michael's Knight]

I have windows 7 access 2013,
i had a query made, and wanted to add fields to it, so i went into the SQL and added several fields. Only the first one i entered didn't work and on the query is called "Expr1003" when in datasheet view. Its right in layout view, and even when i tried adding the same field in layout view, it made it "Expr1004". spelling is correct, in both source table and query, i don't know why this field doesn't work especially when the others did.

 

[Michael's Knight]

SELECT BookDetailsTable.BookTitle, BookDetailsTable.AuthorID, BookDetailsTable.FormatID, BookDetailsTable.Edition, BookDetailsTable.Edition, BookDetailsTable.DateOfEditionRelease, BookDetailsTable.Impression, BookDetailsTable.DateOfImpression, BookDetailsTable.PrinterCompanyID, BookDetailsTable.PublisherOfRecordID, BookDetailsTable.USRetail, BookDetailsTable.USWholesale, BookDetailsTable.PrintCost, BookDetailsTable.CanadaRetail, BookDetailsTable.CanadaWholesale, BookDetailsTable.UKRetail, BookDetailsTable.UKWholesale, BookDetailsTable.Edition, BookDetailsTable.[13DigitISBN], BookDetailsTable.[10DigitISBN], BookDetailsTable.BookSizeID, BookDetailsTable.ColorID, BookDetailsTable.DateOfCompletion, BookDetailsTable.[DatePublished/StreetDate], BookDetailsTable.CopyrightHolder, BookDetailsTable.ProjectStatus, BookDetailsTable.EuropeRetail, BookDetailsTable.EuropeWholesale, BookDetailsTable.USWholesaleDiscount, BookDetailsTable.CanadaWholesaleDiscount, BookDetailsTable.UKWholesaleDiscount, BookDetailsTable.EuropeWholesaleDiscount, BookDetailsTable.USManufactureCost, BookDetailsTable.EuropeManufactureCost, BookDetailsTable.UKManufactureCost, BookDetailsTable.CanadaManufactureCost, BookDetailsTable.Notes
FROM BookDetailsTable
ORDER BY BookDetailsTable.BookTitle, BookDetailsTable.Edition, BookDetailsTable.Edition, BookDetailsTable.Impression;

 

[Michael's Knight]

BookDetailsTable.Edition doesn't appear as "Edition" in the datasheet view. i added the highlighted sql, and the reason there are 2 "BookDetailsTable.Edition" is from trying to add one throught the layout view afterwards.

 

[Michael's Knight]

When i initially changed it in SQL, i had the Expr... problem, so then i tried from the layout view, and got another Expr..., having now removed one it still gives me the Expr...

 

[Michael's Knight]

same happens after i've removed both and tried just from the layout view. there are no relationships directly to that field, i don't know what else could be confusing it.

 

[Michael's Knight]

how do i do that? i am unfamiliar with the clause.

 

[Michael's Knight]

i moved it, and now it says Expr1001, should i try remaking the field in the Table, and then try all this again in the query?

 

[Michael's Knight]

here is the sql

SELECT BookDetailsTable.BookTitle, BookDetailsTable.Edition, BookDetailsTable.Impression, BookDetailsTable.AuthorID, BookDetailsTable.FormatID, BookDetailsTable.DateOfEditionRelease, BookDetailsTable.DateOfImpression, BookDetailsTable.PrinterCompanyID, BookDetailsTable.PublisherOfRecordID, BookDetailsTable.USRetail, BookDetailsTable.USWholesale, BookDetailsTable.PrintCost, BookDetailsTable.CanadaRetail, BookDetailsTable.CanadaWholesale, BookDetailsTable.UKRetail, BookDetailsTable.UKWholesale, BookDetailsTable.Edition, BookDetailsTable.[13DigitISBN], BookDetailsTable.[10DigitISBN], BookDetailsTable.BookSizeID, BookDetailsTable.ColorID, BookDetailsTable.DateOfCompletion, BookDetailsTable.[DatePublished/StreetDate], BookDetailsTable.CopyrightHolder, BookDetailsTable.ProjectStatus, BookDetailsTable.EuropeRetail, BookDetailsTable.EuropeWholesale, BookDetailsTable.USWholesaleDiscount, BookDetailsTable.CanadaWholesaleDiscount, BookDetailsTable.UKWholesaleDiscount, BookDetailsTable.EuropeWholesaleDiscount, BookDetailsTable.USManufactureCost, BookDetailsTable.EuropeManufactureCost, BookDetailsTable.UKManufactureCost, BookDetailsTable.CanadaManufactureCost, BookDetailsTable.Notes
FROM BookDetailsTable
ORDER BY BookDetailsTable.BookTitle, BookDetailsTable.Edition, BookDetailsTable.Edition, BookDetailsTable.Impression;

 

[Michael's Knight]

Like this... still Expr1001

SELECT BookDetailsTable.BookTitle, BookDetailsTable.Edition, BookDetailsTable.Impression, BookDetailsTable.AuthorID, BookDetailsTable.FormatID, BookDetailsTable.DateOfEditionRelease, BookDetailsTable.DateOfImpression, BookDetailsTable.PrinterCompanyID, BookDetailsTable.PublisherOfRecordID, BookDetailsTable.USRetail, BookDetailsTable.USWholesale, BookDetailsTable.PrintCost, BookDetailsTable.CanadaRetail, BookDetailsTable.CanadaWholesale, BookDetailsTable.UKRetail, BookDetailsTable.UKWholesale, BookDetailsTable.Edition, BookDetailsTable.[13DigitISBN], BookDetailsTable.[10DigitISBN], BookDetailsTable.BookSizeID, BookDetailsTable.ColorID, BookDetailsTable.DateOfCompletion, BookDetailsTable.[DatePublished/StreetDate], BookDetailsTable.CopyrightHolder, BookDetailsTable.ProjectStatus, BookDetailsTable.EuropeRetail, BookDetailsTable.EuropeWholesale, BookDetailsTable.USWholesaleDiscount, BookDetailsTable.CanadaWholesaleDiscount, BookDetailsTable.UKWholesaleDiscount, BookDetailsTable.EuropeWholesaleDiscount, BookDetailsTable.USManufactureCost, BookDetailsTable.EuropeManufactureCost, BookDetailsTable.UKManufactureCost, BookDetailsTable.CanadaManufactureCost, BookDetailsTable.Notes
FROM BookDetailsTable
ORDER BY BookDetailsTable.BookTitle, BookDetailsTable.Edition, BookDetailsTable.Impression;

 

[Michael's Knight]

Genius! That was it! I'll take this as a lesson to be thoroughly meticulous in the future... Thank you so much for your time!