i've been trying to solve this and am going mad. Please help. I'm working with a community group and i'm a real novice at this :'(
We have an asp page called input.asp where a user puts in their postcode(zip) code which is 4 numbers e.g. 2050. The idea is that the page input.asp searches a table called Events in an Access database to find out "what's on" in and around their postcode and the results of the search are reported on a page called resultsevents.asp. We want it to report events for a range of postcodes nearby e.g. if the user types in 2050 they should get information for what's on at 2040, 2041, 2042 etc up to 2060 and everything in between.
I've been sitting here for six hours trying to get the syntax right! I've tried BETWEEN I've TRIED < and > and I've tried everything I know till I'm about to burst into tears.
Right now the 250th try the section of code in resultsevents.asp looks like :
SQL_SearchWhere = "(Postcode BETWEEN ('Postcode%-10 AND Postcode+10" & SearchFor & "%'))"
I can't get it turn return any results except for those that exactly match the postcode input by the user on input.asp
Please , if you can help I would be very grateful.