Lookup query

[kingsgambit]

I have a table linked to a sql database, I want to run a query that will only show certain depots but not sure how.
i.e weston,london
I can run a query that will work if I put in a single depot but I need a query that I can have serveral depots

 

[gemma-the-husky]

put ="weston" or "london" in the criteria.
you can put between "weston" and "london" also, but this will pick up any others in between. Case is not significant in the criteria. "WESTON" or "weston" will both work. The order of criteria in a between clause is not significant. Between "w" and "l" is the same as between "l" and "w"

It will start to get awkward though, if you want to change the depots on which you are searching dynamically.



You ought to give some thought to having numeric ID's for your depots rather than text, and linking on the numeric id's, if you've not taken this too far.