hai expert,
I have a query like this
FROM DBO.OINV T0
WHERE
T0.Project >= '%0' AND T0.Project <= '%1'AND
T0.U_Hotel >= '%2' AND T0.U_Hotel <= '%4'AND
Date = '%5' AND Month >= '%6'AND Month<= '%7'
'AND Years= '%8'
Group By T0.Project, T0.U_Hotel
and want to add search for dates, Month, Years
how to make a query to display like this:
Project Code, Hotel, Qty Hotel, Days , Month, years
A, XXX, 10, 25, November, 2009
B, XXX, 15, 25, Oktober, 2009
thx for all