Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello,
I'd try
FROM $(cFileName) (qvd) WHERE DealNumber >= 1000000 AND DealNumber <= 2000000
Any help anyone?....
Hello,
I'd try
FROM $(cFileName) (qvd) WHERE DealNumber >= 1000000 AND DealNumber <= 2000000
Hi,
If i understood my question, below is your answer
FROM $(cFileName) (qvd) WHERE DealNumber >= 1000000 and DealNumber <= 2000000 ;
- Peterson
Excellent, that worked. Thanks for your help.
Easy when you know how!