I am new to queries so forgive me if i appear a bit lost.
I am construsting a query to show me unfufilled product orders and the products that have not yet been delivered yet for each product order.
I have joined 4 tables Product Order, Product Order Line, Supplier and Product.
What i want to see is for each unfufilled order, the supplier and all the related undelivered product order lines( a product order is fufilled when all product order lines are delivered and the product order status attribute then set to yes by the user)
I have entered all the fields into the query and the criteria I have entered is "no" for product order status attribute for the product order table, and " " in the Supplier Invoice No attribute in the Prodcut Order Line table, as product order lines are filled when the supplier invoice no is entered, however when i run this i get the message "data type mismatch in criteria expression"
Does what i am doing sound right for this type of query?
Any help would be greatly appraciated.
I am construsting a query to show me unfufilled product orders and the products that have not yet been delivered yet for each product order.
I have joined 4 tables Product Order, Product Order Line, Supplier and Product.
What i want to see is for each unfufilled order, the supplier and all the related undelivered product order lines( a product order is fufilled when all product order lines are delivered and the product order status attribute then set to yes by the user)
I have entered all the fields into the query and the criteria I have entered is "no" for product order status attribute for the product order table, and " " in the Supplier Invoice No attribute in the Prodcut Order Line table, as product order lines are filled when the supplier invoice no is entered, however when i run this i get the message "data type mismatch in criteria expression"
Does what i am doing sound right for this type of query?
Any help would be greatly appraciated.
