When I Select a CITY the following Query shows the price list of that city. - This is working Fine
In the table and in field PlantLoc is defined. there are 3 PlantLoc
1. Gujranwala
2. Islamabad
3. Rahim Yar Khan
Now I want To Add Another 4th Plantloc "Lahore" but this should show along with the all 3 Plantloc
Example if I select Gujranwala it should show price list of:
Gujranwala + Lahore
Islamabad + Lahore
Rahim Yar Khan + Lahore
What modification shoud I do in the following Query
SELECT Cities.Cities FROM Cities WHERE (((Cities.Cities) In ("Gujranwala","Rahim Yar Khan","Islamabad"))) ORDER BY Cities.Cities;
SELECT [Price List Querry].Description, [Price List Querry].CCIDescripCode, [Price List Querry].[Off Price], [Price List Querry].Units, [Price List Querry].[GST Percent], [Price List Querry].[Serial Id], [Price List Querry].PlantLoc, [Price List Querry].[From Date], [Price List Querry].Catagory FROM [Price List Querry] WHERE ((([Price List Querry].PlantLoc)=Forms.[Admin Purchase].[Purchase Subform].FORM.Ploc) And (([Price List Querry].[From Date])>#6/9/2018#)) ORDER BY [Price List Querry].Description;