Skip to Content
0
Former Member
Jul 14, 2008 at 07:40 AM

SQL Statement

23 Views

Hello togeather,

If i create a Purchase Order Query and add in the end the fallowing statement:

WHERE T1.DocNum = '[%0]' AND T0.ItemCode = '[%1]' AND T1.CardCode = '[%2]'

than i got a mask where i can fill the values. But if i fill nothing than i got 0 records. What can i do to show everything if i fill nothing..

and another questin is can i add here a range e.g. i want to sea the DocNum from 1-10..

thank you all and best regards

Serkan