Creating a search function
Okay i have a table created in Access with these fields ...
I am making a search form for it ..The problem is i can just get a better way to creat a search function ..The way i am creating it is just to lenghty ..This is what i am doing
if ( cno And Date And Kgms And Amount And Destination And ORigin are not empty )
use the Select SQL statement Where Cno is this blah blah
else if ( cno And Date And Kgms And Amount And Destination is not empty but Origin is )
use SQL statement where ...
U get the idea right i have to right too many if else ....How can i get rid of that