"Select CN,CNM,TNO,TDT,TOTAL from FLTransactionsTable Where [CN] LIKE '" & txtSearchCustNo.Text & "' AND WHERE [TNO] BETWEEN '" & txtTNOFROM.Text & "' AND '" & txtTNOTO.Text & "' ORDER BY TDT Desc"
Code:
Text & "' AND '" & txtTNOTO.Text & "' ORDER BY TDT Desc"
Select CN,CNM,TNO,TDT,TOTAL from FLTransactionsTable Where [CN] LIKE '" & txtSearchCustNo.Text & "' AND WHERE [TNO] BETWEEN '" & txtTNOFROM.Text & "' AND '" & txtTNOTO.Text & "' ORDER BY TDT Desc
Last edited by Zvoni; Tomorrow at 31:69 PM.
----------------------------------------------------------------------------------------
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------------------
People call me crazy because i'm jumping out of perfectly fine airplanes.
---------------------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad
Last edited by Zvoni; Tomorrow at 31:69 PM.
----------------------------------------------------------------------------------------
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------------------
People call me crazy because i'm jumping out of perfectly fine airplanes.
---------------------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad
I have another sort of problem, when you read your old posts and find that you have posted the exact same question twice but have no memory of the first post whatsoever.
Skillset: VMS,DOS,Windows Sysadmin from 1985, fault-tolerance, VaxCluster, Alpha,Sparc. DCL,QB,VBDOS- VB6,.NET, PHP,NODE.JS, Graphic Design, Project Manager, CMS, Quad Electronics. classic cars & m'bikes. Artist in water & oils. Historian.
By the power invested in me, all the threads I start are battle free zones - no arguing about the benefits of VB6 over .NET here please. Happiness must reign.