Search results

I have created a query to calculate the sub total, VAT and the total amount but when I run the query I get the message: "You tried to execute a query that does not include the specified expression '[Price]*[Quantity]' as part of an aggregate function" can someone help please?

can someone tell me how to make a form's data change when related data is changed in another form. E.g. If I change the price of a product in 'products' to £3.00, how do I make it automatically show that it is £3.00 in 'orders' just by typing in the product code?

yes but it shows the old data in the new order which I don't want

can someone help: in a form I've created showing products bought, when I add a new new order it still keeps the previous order's data, how can I prevent that from happening? cheers