Search results

Im trying to calculate the sum of the total ive got this total = [stockprice] *[QuantityOrdered] =sum([stockprice] *[QuantityOrdered]) this works however when there are two records being shown it just gives the total sum of both records only want it to give one for each record really need to...

Need to do a query that shows the goods that have not been sent in a database. Have got the form set up with Delivery Date and Order Date - Order Date being the date that the order was made and delivery day is 7 from the order date. need the code to put in the query any ideas???? Really...

Wondering if you do an update query in Access 2002 is it possible that it wont work in 2000??? (Done a update query today in 2002 and now won't work on 2000!!???!!!)

hello looking for some help on mainting stock levels!! - allow for quantity on hand - amount on order - amount sold there is a stock table set up with following fields ; StocKCODE stockdescription stockprice stockquantity stock items in delivery we want to add the new number of stock...