hai expert...
I have this query and I try not to work
how to make this query work for display like this:
1
SELECT
T0.Project, T0.U_Hotel, COUNT(T0.U_Hotel) AS 'Qty Hotel' ,
T0.[U_Nationality],COUNT(T0.[U_Nationality]) AS 'QtyNationality '
FROM DBO.OINV T0
WHERE
T0.Project >= '[%0]' AND T0.Project <= '[%1]'AND
T0.U_Hotel >= '[%2]' AND T0.U_Hotel <= '[%3]'AND
T0.[TaxDate]= '[%4]' AND T0.[U_Nationality] = '[%5]'AND
Group By T0.Project, T0.U_Hotel
how to make this query work for display like this:
ProjectCode, Hotel ,Tot Hotel, Nationality, Tot Natinality
AAA, XXX, 5, AU, 15
2. SELECT
T0.Project, T0.[U_Nationality], COUNT(T0.[U_Nationality]) AS 'QtyNationality'
FROM DBO.OINV T0
WHERE
T0.Project >= '[%0]' AND T0.Project <= '[%1]'AND
T0.[U_Nationality]>= '[%2]' AND T0.[U_Nationality] <= '[%3]'
T0.[TaxDate]>= '[%4]' AND T0.[U_Nationality] <= '[%5]'AND
Group By T0.Project, T0.[U_Nationality], T0.[TaxDate]
how to make this query work for display like this:
ProjectCode,Nationality, Tot Natinality
AAA,AU, 5
thx for all