Search results
-
F
Date Range with Partial Overlap - Is This Possible?
I'll apologize in advance that I'm new to Access. I'm trying to return results in a query where dates within two fields fall within, or partially within, date parameters that the user is prompted for. In other words. I have two fields: [Open Date] and [Closed Date]. The user will be... -
F
Work Days Difference, Need Same Day = 1
Greetings, I'm working on a query that returns the work days difference between two dates, and divides that by a larger number of days to get a percentage. I need dates that are the exact same to return a value of 1, so that when it does the division it's not dividing 0, and eventually...