i currently have this in my vb 6 app with a access db
so the above only selects records that has date info, "SlideHasDateOnlyDate ", and where that date, "SlideDisplayOnlyDate ", is today and this works great. however i now want to also include records that dont have a date in them, which means it can be displayed on any date, and also select them. is it possible to have it both ways in one select statement?Code:"Select * From BoardSlides WHERE SlideHasDateOnlyDate = -1 AND SlideDisplayOnlyDate = #" & Format(Date, "mm/dd/yyyy") & "# ORDER By SlideName"




Reply With Quote