Posted by jerryyang_la1 on 06/15/17 11:58

> I really don't know the syntax, dbms or system you are using, but the
> following is consistent with your example and performs the required
> logic. You didn't ask (or show DDL etc.) but from your example and
> requirements your database table is far from 1NF and needs looking at.
>
> "SELECT * FROM tbl" &_
> "WHERE ( CDATE(Date) = #" & dtOnDay &
> "# OR Date2 = #" & dtOnDay &
> "# OR Date3 = #" & dtOnDay &
> "# OR Date4 = #" & dtOnDay &
> "# OR Date5 = #" & dtOnDay &
> "# OR Date6 = #" & dtOnDay &
> "# OR Date7 = #" & dtOnDay &
> "# )" &
> "AND ( userID = #" & SearchedUsername &
> "# OR userID2 = #" SearchedUsername &
> "# )

Hi Thanks I will try this.

Can you please "You didn't ask (or show DDL etc.) but from your
example and
> requirements your database table is far from 1NF and needs looking at."

CHerers

[Back to original message]