Help with editing my script...

[hopkinsc]

Hi, this will be an easy one to answer,

I am reporting on transactions for my company,I need to display my results for transaction numbers between 1000000 - 2000000 and exclude everything else.

i know how to show values under a number i,e show values below transaction number 1000000.

FROM $(cFileName) (qvd) WHERE DealNumber < 1000000 ;

But how do i stop it from displaying values higher than 2000000

Thanks

[hopkinsc]

Any help anyone?....

[Miguel_Angel_Baeyens · Accepted solution]

Hello,

I'd try

FROM $(cFileName) (qvd) WHERE DealNumber >= 1000000 AND DealNumber <= 2000000

[#4]

Hi,

If i understood my question, below is your answer

FROM $(cFileName) (qvd) WHERE DealNumber >= 1000000 and DealNumber <= 2000000 ;

- Peterson

[hopkinsc]

Excellent, that worked. Thanks for your help.

Easy when you know how!