![]() FROM Bankbook WHERE (Bankbook. ![]() ![]() ![]() I moved the columns around and at one time had the same error but with the CreditAmount field. I know how to get a Pass Through Query running for a simple query but I get stuck with the following SPT query (SQL Passthrough): SELECT Bankbook.Date, Bankbook.SeasonID, Bankbook.Data1, Bankbook.Data2. Make sure you have typed the name correctly, and try the operation again. , TransactionDate ) SELECT (Select Attendees.AttendeeID FROM Attendees WHERE Attendees.Title = ) AS Expr1, Transaction., Transaction.CreditAmount, Transaction.Note, Transaction.TransactionDate FROM Attendees INNER JOIN ON Attendees.AttendeeID = Transaction.RetireeID WHERE (((Transaction.)=) AND ((Transaction.CreditAmount)=) AND ((Transaction.TransactionDate)=)) Īnd I am now receiving an error of The INSERT INTO statement contains the following unknown field name: ‘Transaction.RetireeID’. Pulling a select within a select AKA update.
0 Comments
Leave a Reply. |