is there a sequel command for 'and or' ?

Results 1 to 3 of 3

Thread: is there a sequel command for 'and or' ?

  1. #1
    mark Guest

    Default is there a sequel command for 'and or' ?

    I&#039m trying to make my sequel statement lookup to fields in the database to sum up numbers and an &#039and or&#039 statement would be convienent here. does anybody know what that command would look like? my sequel statement looks like this:<BR><BR>("SELECT COUNT(StatusID) AS StatusCount FROM StudentClasses WHERE StatusID = &#039R&#039 and or &#039P&#039 AND ClassID = " & Rs("ClassID"))<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE:Just Or...

    Is this what your looking for ??<BR><BR>WHERE (StatusID = &#039R&#039 or StatusID = &#039P&#039 ) AND ClassID = " & Rs("ClassID"))<BR>

  3. #3
    mark Guest

    Default RE:Just Or...

    ahh...yes. thank you sir.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts