Skip to Content
0
Former Member
Feb 29, 2008 at 08:05 PM

Aggregating in query

10 Views

Hi ,

I am facing osme problem with multiporvder reporting for example

0material |Transactionnumber| Compalintnumber| Docdate| compalint date| no of days

150051| 01| 10| 5/06/2007/| 5/07/2007| 30 days

150051| 01| 10| 5/06/2007| 5/07/2007| 30 days

But in query i am getting as

0material |Transactionnumber| Compalintnumber| Docdate| compalint date| no of days

150051| 01| 10| 5/06/2007/| 5/07/2007| 60 days(30 Days)

i want to get the number as 30 days.....

How its happening......

Thanx in advance

Regards

Ram

Edited by: Ram on Mar 1, 2008 1:40 AM