Look up a date in a table with a list of multiple start and dates and return a default value if found

[dnwadams]

Hi All,

I am having some trouble trying to create a query that will return a default value if the date being looked up falls between any of the start and end times in another table.

The date being looked up is in table1 and start and end dates are in table2. I need for the value in table 1 to be compared to each of the start and end dates in table2.

So what i would like is if [table1].[date] is between any of the list of [table2].[startdate]'s and [table2].[enddate]'s then the value "TRUE" to be shown, otherwise [table1].[value] to show.

Hopefully this makes sense, thanks in advance!

 

[Smitty]

Welcome to the Board!

Please see this note on Crossposting.

No harm done, we just ask that you post a link to your other post as well.

 

[dnwadams]

Hi Smitty,

Thanks for letting me know about this i will ensure to keep this in mind going forward.

For some reason its not allowing me to edit my post though?

 

[alansidman]

Here is the crosspost reference for you: Look up a date in a table with a list of multiple start and dates & return a default value

 

[Smitty]

For some reason its not allowing me to edit my post though?

Yeah, you only have about 10 minutes.