Database

AVG (Enrollment.Marks_obtained = 1/3 * avg_second_year_marks + 2/3 * avg_third_year_marks) AS Overall_Marks

Quote:

but it says "the field PLU could refer to more than one

BrunoPigeon wrote:

I am new to SQL and am trying to learn, hence asking on this forum.

Select 
    distinct format(SupplierInvoices.Date, 'dd-MMM-yyyy') as tDate, 
    Sum(SupplierInvoices.QTY) as lTotal 
from SupplierInvoices 
where PLU = '" & lblPLU.Caption & "' 
    and Date Between #" & StartTime & "# and #" & EndTime & "# 
Group by format(SupplierInvoices.Date, 'dd-MMM-yyyy') 
Union 
Select 
    distinct format(Sales.Date, 'dd-MMM-yyyy') as tDate, 
    Sum(Sales.QTY) as sTotal 
from Sales 
where PLU = '" & lblPLU.Caption & "' 
    and Date Between #" & StartTime & "# and #" & EndTime & "# 
Group by format(Sales.Date, 'dd-MMM-yyyy')

NGAYGIAO BETWEEN #01/01/2019# AND #31/01/2019#

for (int i = 0; i < [Original data].Count; i++)
            { 
                bool BOOLEAN = 0;
                string SOHD = "";
                if([NGAYGIAO].[i]>=#1/1/2019# && [NGAYGIAO].[i] <=#1/31/2019#) //dd/MM/yyyy
                {
                   for (int j = 0; j < [Original data].Count; j++)
                   {
                       if([LOAIHD].[j] == "FBAN") 
                        {
                            BOOLEAN = 1;
                            SOHD = [Original data].[HD].[j];
                        }<br />
                   }
                }
                if(SOHD == [Original data].[HD].[i] && SOHD != "")
                {
                    [Result].[BOOL].[i] = BOOLEAN;
                }
            }