Hi,

Im having a problem with the SQL Query wizard. I get the following error message. "The schema returned by the new query differs from the base query".

Heres the code below that was generated from what i wanted to achieve;

Code:
SELECT     [Order].OrderID, [Order].Review, Customer.CustomerID, Customer.CustomerName, Customer.PhoneNumber, Card.CardID, Card.CardNumber,  Card.ExpiryDate, Delivery.DeliveryID
FROM         ((([Order] INNER JOIN
                      Card ON [Order].CardID = Card.CardID) INNER JOIN
                      Customer ON Card.CustomerID = Customer.CustomerID) INNER JOIN
                      Delivery ON [Order].DeliveryID = Delivery.DeliveryID AND Customer.CustomerID = Delivery.CustomerID)
WHERE     ([Order].Review = TRUE)
Firstly i have a blank form, created the link to the database. dragged the 'order' data on the form and clicked on query builder to display additional data.

Basically the code is looking at 4 different tables. pulling all the information i need where 'Review' (checkbox) is TRUE. Basically i want to see just the items where the checkbox is ticked. When i click execute query, i can see the preview and looks fine. But when i click OK i get the error message as above.

Any ideas?