complex query

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Vincent Jones

    complex query

    guys and gals i'm stuck..
    i wanna create a query that only returns one record for weekdays and
    all records for the weekends
    so if I have records listing events for the month i see every record
    listed on the weekend but on the one record for the weekday because it
    will have the same title regardless the time.

    eventtitle day time
    vangogh sept 4 10am
    vangogh sept 4 11am
    vangogh sept 4 12 noon
    vangogh sept 6 n/a
    vangogh sept 6 n/a
    vangogh sept 6 n/a

    so if I had a query that displayed...
    eventtitle day time
    vangogh sept 4 10am
    vangogh sept 4 11am
    vangogh sept 4 12 noon
    vangogh sept 6 n/a

    ....life would be special.
    thanks.
Working...