Skip to Content
0
Former Member
Nov 25, 2009 at 09:08 AM

Qty dd/ mm /yy

41 Views

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