SELECT SUM(a.Quantity*(SELECT TOP 1 b.intPrice FROM floatPrice b WHERE b.pDate<=a.operDate AND a.prodID=b.prodID ORDER BY b.pDate desc)) 
FROM floatOper AS a;

SELECT a.prodid, 
       d.produnit, 
       d.prodname, 
       (SELECT TOP 1 z.prodprice 
        FROM   products z 
        WHERE  d.prodid = z.prodid 
               AND z.pricedate <=# 09 / 20 / 2016# 
        ORDER  BY z.pricedate DESC), 
       c.quantity                                                 AS BegRem, 
       SUM(Iif(b.opername = 'prihod' 
               AND b.operdate <# 09 / 20 / 2016#, b.quantity, 0)) AS Prihod, 
       SUM(Iif(b.opername = 'realiz' 
               AND b.operdate <# 09 / 20 / 2016#, b.quantity, 0)) AS Realiz, 
       SUM(Iif(b.opername = 'spisanie' 
               AND b.operdate <# 09 / 20 / 2016#, b.quantity, 0)) AS Spisanie, 
       SUM(Iif(b.opername = 'vozvrat' 
               AND b.operdate <# 09 / 20 / 2016#, b.quantity, 0)) AS Vozvrat, 
       Iif(begrem IS NULL, 0, begrem) + prihod 
       + vozvrat - realiz - spisanie                              AS EndRem 
FROM   ((((((SELECT prodid 
            FROM   remains 
            WHERE  salid = 19 
            UNION 
            SELECT a.prodid 
            FROM   operations a, 
                   users b 
            WHERE  a.usrid = b.usrid 
                   AND b.salid = 19) a 
            LEFT JOIN operations b 
                   ON a.prodid = b.prodid) 
           LEFT JOIN remains c 
                  ON a.prodid = c.prodid) 
          LEFT JOIN products d 
                 ON a.prodid = d.prodid) 
         LEFT JOIN users e 
                ON b.usrid = e.usrid) 
        LEFT JOIN bases f 
               ON d.basid = f.basid) 
WHERE  e.salid = 19 
       AND f.srvflag = 0 
GROUP  BY a.prodid, 
          d.produnit, 
          d.prodname, 
          (SELECT TOP 1 z.prodprice 
           FROM   products z 
           WHERE  d.prodid = z.prodid 
                  AND z.pricedate <=# 09 / 20 / 2016# 
           ORDER  BY z.pricedate DESC), 
          c.quantity 
ORDER  BY d.prodname 

SELECT a.prodid, 
       d.produnit, 
       d.prodname, 
       d.prodprice, 
       c.quantity                                                 AS BegRem, 
       SUM(Iif(b.opername = 'prihod' 
               AND b.operdate <# 09 / 20 / 2016#, b.quantity, 0)) AS Prihod, 
       SUM(Iif(b.opername = 'realiz' 
               AND b.operdate <# 09 / 20 / 2016#, b.quantity, 0)) AS Realiz, 
       SUM(Iif(b.opername = 'spisanie' 
               AND b.operdate <# 09 / 20 / 2016#, b.quantity, 0)) AS Spisanie, 
       SUM(Iif(b.opername = 'vozvrat' 
               AND b.operdate <# 09 / 20 / 2016#, b.quantity, 0)) AS Vozvrat, 
       Iif(begrem IS NULL, 0, begrem) + prihod 
       + vozvrat - realiz - spisanie                              AS EndRem 
FROM   ((((((SELECT prodid 
            FROM   remains 
            WHERE  salid = 19 
            UNION 
            SELECT a.prodid 
            FROM   operations a, 
                   users b 
            WHERE  a.usrid = b.usrid 
                   AND b.salid = 19) a 
            LEFT JOIN operations b 
                   ON a.prodid = b.prodid) 
           LEFT JOIN remains c 
                  ON a.prodid = c.prodid) 
          LEFT JOIN products d 
                 ON a.prodid = d.prodid) 
         LEFT JOIN users e 
                ON b.usrid = e.usrid) 
        LEFT JOIN bases f 
               ON d.basid = f.basid) 
WHERE  e.salid = 19 
       AND f.srvflag = 0 
GROUP  BY a.prodid, 
          d.produnit, 
          d.prodname, 
          d.prodprice, 
          c.quantity 
ORDER  BY d.prodname

SELECT b.prodName, (SELECT TOP 1 c.prodPrice FROM products c WHERE a.prodID=c.prodID AND c.priceDate<=#09/19/2016# ORDER BY c.priceDate desc) AS Cen
FROM operations AS a, products AS b
WHERE a.prodID=b.prodID AND a.operDate=#09/19/2016#;