Posted by jerryyang_la1 on 10/05/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

• Next in forum: Re: Help with a query please !! It works but needs adjusting !
• Prev in forum: Re: Looking for the right mysql syntax
• Thread view: Re: Help with a query please !! It works but needs adjusting !

[Reply to this message]