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#;

SELECT a.prodID,d.prodName,
SUM(Iif(b.opername = 'realiz' AND b.operdate <#09/01/2016#, ((SELECT TOP 1 z.prodprice FROM   products z WHERE  a.prodid = z.prodid  AND  z.pricedate <=# 09 / 01 / 2016# ORDER  BY z.pricedate DESC)*b.quantity), 0)) AS Realiz
      
FROM   (((
(select prodID from remains WHERE salID=19
UNION
SELECT DISTINCT a.prodID FROM operations a, users b, crossbase c, products d WHERE  c.useFlag=1 AND c.salID=19 AND b.salID = c.salID AND c.basID=d.basID AND d.prodID=a.prodID) AS a
           LEFT JOIN operations AS b ON a.prodid = b.prodid)
          LEFT JOIN remains AS c ON a.prodid = c.prodid)
         LEFT JOIN products AS d ON a.prodid = d.prodid)
GROUP BY a.prodID,d.prodName
ORDER  BY d.prodname; 

	var RS = MDB.OpenRecordset(	"SELECT \
						a.prodID, \ 
						d.prodName, \
						d.prodUnit, \
						(SELECT TOP 1 z.prodPrice FROM products z WHERE a.prodID=z.prodID AND z.priceDate<=#"+sqlBeginDate+"# ORDER BY z.priceDate DESC) AS prodPrice,\
						c.Quantity AS RNP, \
						ROUND((SELECT TOP 1 z.prodPrice FROM products z WHERE a.prodID=z.prodID AND z.priceDate<=#"+sqlBeginDate+"# ORDER BY z.priceDate DESC)*c.Quantity,2) AS RNPAmnt, \
						SUM(IIF(b.operName='realiz' AND b.operDate<#"+sqlBeginDate+"#, ((SELECT TOP 1 z.prodPrice FROM products z WHERE a.prodID=z.prodID AND z.priceDate<=#"+sqlBeginDate+"# ORDER BY z.priceDate DESC)*b.Quantity), 0)) AS Realiz, \
						SUM(IIF(b.operName='realiz' AND b.operDate BETWEEN #"+sqlBeginDate+"# AND #"+sqlEndDate+"#, ((SELECT TOP 1 z.prodPrice FROM products z WHERE a.prodID=z.prodID AND z.priceDate<=b.operDate ORDER BY z.priceDate DESC)*b.Quantity), 0)) AS PRealiz \
					FROM ((( \
						(SELECT prodID from remains WHERE salID=19 \
						UNION \
						SELECT DISTINCT a.prodID FROM operations a, users b, crossbase c, products d WHERE c.useFlag=1 AND c.salID=19 AND b.salID=c.salID AND c.basID=d.basID AND d.prodID=a.prodID) AS a \
						LEFT JOIN operations AS b ON a.prodid = b.prodid) \
						LEFT JOIN remains AS c ON a.prodid = c.prodid) \
						LEFT JOIN products AS d ON a.prodid = d.prodid) \
					GROUP BY \
						a.prodID, \
						d.prodName, \
						d.prodUnit, \
						c.Quantity \
					ORDER BY \
						d.prodname;");