Recent content by cath240

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...

Put this behind the on click - event procedure - Dim stDocName As String Dim stLinkCriteria As String stDocName = "report name" stLinkCriteria = "[label of autonumber]=" & Me![label of autonumber] DoCmd.OpenReport stDocName, , , stLinkCriteria This prints...

try having the report menu form opened when you are running the query.

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...