[Solved] How build Query String [closed]

by


  1. SELECT * FROM YourTableName WHERE bday=’Sun’ AND (branch=”Jamnagar City” OR branch=”Reliance”)

  2. SELECT * FROM YourTableName WHERE bday=’Sun’ AND (branch=”Jamnagar City” OR branch=”Reliance” OR branch=”TATA”)

I believe you can use the IN command, but I’m not positive if it works in Access. You can try it though. Syntax would be:

SELECT * FROM YourTableName WHERE bday=’Sun’ AND branch IN (‘Jamnagar City’, ‘Reliance’, ‘TATA’)

1

solved How build Query String [closed]