[Axapta-Knowledge-Village] how to add same field into qbds by getting AND condition instead of OR in debugg

[giridharraj]

Hi,

I have a problem..........

I take salestable in qbds
and add range as delivery date with value in between 19/12/2008 to 20/12/2009
and again when i add the same range with a value equal to 15/12/2009 then the 
query is changing.

Like i need the query as 
select * from salestable where ((DeliveryDate >=19/12/2008) && (DeliveryDate 
<=20/12/2009)) AND DeliveryDate== 15/12/2009

but in the debugger when i check the qbds it is showing as follows :
select * from salestable where ((DeliveryDate >=19/12/2008) && (DeliveryDate 
<=20/12/2009)) OR DeliveryDate== 15/12/2009

So, Please help me in solving this. What do i need to give at qbds or qbr to 
get AND condition instead of OR.

Thanks and regards,
giridhar Raj.