I already kno wthe very basics, I have a few textbox with an autopost back, and they are setup so when the user enters a string and tabs out of the textbox, what they entered goes into my query parameters, thus filtering the data. Simply Right? The problem I'm having is that I want to filter for a quote number. If the user knows the Quote number they enter it and away we go. However I found that if they don't enter a Quote # and that field/textbox is left blank, none of the other filters work. I'm assuming this is an issue with my query but I just can't figure out how to fix it. Any ideas???
Here is my quesy as of right now:
SELECT Quote#, Date, Company, PU1FromTown, PU1FromState, PU1FromZip, PU1ToTown, PU1ToState, PU1ToZip, PU2FromTown, PU2FromState, PU2FromZip, PU2ToTown, PU2ToState, PU2ToZip, PU3FromTown, PU3FromState, PU3FromZip, PU3ToTown, PU3ToState, PU3ToZip, PU4FromTown, PU4FromState, PU4FromZip, PU4ToTown, PU4ToState, PU4ToZip, Pieces, Weight, Commodity, Rate, RatePer, AccessorialCharges, FSCPercentage, FreightCharges, Notes, ServiceType, [3rdPartyCarrier], CarrierPhone, CarrierFax, CarrierNote, AccessorialPayables, FSCPayables, FreightPayables, NotesPayables FROM Quotes
WHERE (Company = ISNULL(@Company, Company) OR Company LIKE '%' + @Company + '%')
AND ([3rdPartyCarrier] = ISNULL(@3rdpartycarrie
View Complete Post