[RESOLVED] Access sql question

[seanwpb]

i currently have this in my vb 6 app with a access db

"Select * From BoardSlides WHERE SlideHasDateOnlyDate = -1 AND SlideDisplayOnlyDate = #" & Format(Date, "mm/dd/yyyy") & "# ORDER By SlideName"

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?

[si_the_geek]

Use an OR in your Where clause, eg:

Change this:

 AND SlideDisplayOnlyDate = #" & Format(Date, "mm/dd/yyyy") & "#

..to:

 AND (SlideDisplayOnlyDate = #" & Format(Date, "mm/dd/yyyy") & "# OR SlideDisplayOnlyDate Is Null)

[seanwpb]

thanks SI, one question. once a value is set to SlideDisplayOnlyDate then the user changes it back to not having a date its no longer null right? so in my update i can force it back to null right?

[Hack]

Make that a test case and try it.

I am pretty sure I know what will happen, but this is something you should be testing for yourself. If your test case fails then you would have an issue we could help you with.

[seanwpb]

this is what i went with and it works great. thanks

"Select * From BoardSlides WHERE (SlideHasDateOnlyDate = -1 AND SlideDisplayOnlyDate = #" & Format(Date, "mm/dd/yyyy") & "#) OR SlideHasDateOnlyDate = 0 ORDER By SlideName"