2007 error

[Mike Painter]

I converted a 2003 database to 2007 and when I ran it one of the subforms
showed all the proper information but when I clicked on a label I got this
in an error message.

[select
Charges].[TransactionNumber,Charges].[siteID,Charges].[Transactioncode,Charges].[qty,charges].[Charge,Charges].[TransactionDate,NewTransactionCodes].[TranactionDescription,qty]*[charge]
AS totalCharge FROM Charges LEFT JOIN NewTransaction.

Here is the code as it appeared in the SQL query builder window.

SELECT Charges.TransactionNumber, Charges.siteID, Charges.TransactionCode,
Charges.qty, Charges.Charge, Charges.TransactionDate,
NewTranscationCodes.TransactionDescription, [qty]*[charge] AS totalCharge
FROM Charges LEFT JOIN NewTranscationCodes ON Charges.TransactionCode =
NewTranscationCodes.TransactionCodes
ORDER BY Charges.TransactionDate DESC;

I "solved" the problem by cutting and pasting the code into another query. I
made no other changes but the program is happy now.

 

[Allen Browne]

Weird. Who knows why it would give that weird interpretation of the
statement, or associate it with a label.

Glad you got it sorted out anyway.