Search results

  1. N

    How to subtract values from two fields in two consecutive rows in Access table?

    Hi, I have a table with unique number of vehicle and the shift it works in. There are columns for number of vehicle, shift, starting km and ending km. I want to subtract or only compare the values form the columns ending km and starting km from the consecutive rows depending on the shift. I...
  2. N

    Combining selects in one select in access query

    Hello, I have three tables and I use fields from all of them, and aggregate functions to make select for my report. I tried to make separate selects that return separately correct values, but I don't know how to combine them and get one select in the query which I will use for the Crystal...
  3. N

    Sum(iif()) function problem

    Hi, I have this select SELECT NOVI.GBR, NOVI.AB, Min(IIf(([NALOG1.DATA]>=[@data1]) And ([NALOG1.DATA]<=[@data2]) And ([NALOG1].[POCKM]>0),[NALOG1.POCKM],Null)) AS pockm, Max(IIf(([NALOG1.DATA]>=[@data1]) And ([NALOG1.DATA]<=[@data2]),[NALOG1.KRAJKM],Null)) AS krajkm...
  4. N

    Problem with the sum function in quey select

    here is my table MAGACIN GBR DATA SIFRA IME KOL 1001 18.10.2011 0991000 DIZEL GORIVO 45 1001 18.10.2011 0991000 DIZEL GORIVO 55 1001 21.10.2011 0992201 AD-BLU 12 1001 22.10.2011 0991000 DIZEL...
Back
Top Bottom