Search results

  1. T

    If - else error?

    I have a query as follows Private Sub StockOK_Click() Dim SQLDelete1 As String Dim SQLDelete2 As String Dim SQLUpdate As String Dim SQLStore As String SQLDelete1 = "DELETE * FROM TblStock WHERE TblStock.ProductID = " & CboStockItem.Value SQLDelete2 = "DELETE * FROM TblTotalSale WHERE...
  2. T

    Insert Into

    so I have a query that will insert into a table some values. It goes as follows INSERT INTO TblStockFinal (StockLevels) SELECT (SUM(QrySales1.SalesByHalfPintBottleorCan)) FROM QrySales1 WHERE QrySales1.ProductID=1 OR QrySales1ProductID=2; but this is not working. Any Idea why.
  3. T

    Count, but some as Halves

    Hey. So this is for my dissertation and it is coming allong pretty well. almost finished it now xD Anyway, I'm making a pub Epos system in access and its all OK, except now I have reached the stock control. To get the query (Stock = Stock - Sales) I need to do a count query, which is easy...
  4. T

    cross table subtraction with a “where” clause

    so I have a number of table in my access database. one of the tables is called "tblCurrentSale" and another is called "TblDraughtStock" The current sales table has the following layout CurrSaleID| DraughtID| SpiritID| SoftDrinkID| BottleID| Item__| SalePrice|...
  5. T

    Subreport on form. sum() not working well?

    Hey I have a form which has two subreports on it, each with a column of numbers (Currency) and a totals bit at the bottom which adds up the values added. I have used the me.Refresh command alot, and new lines in the reports show up, but for some reason the totals box at the bottom only shows...
  6. T

    IF SUM(column)<= 0 then

    (Solved) IF SUM(column)<= 0 then Hi All I am making a till system for a project in access and I have hit a block. *Background* There are numerous forms covered in buttons. clicking a button adds data to a table (TblCurSale) including description and price of item. each form also has a...
Back
Top Bottom