I can't get this to work. Do I just replace the firstdate and seconddate with my table names? what else do I do to this statement? I'm assuming this goes into the "build" area of my select query?
Not table names ... field names. I just used [FirstDate] and [SecondDate] as place holders for the two date fields that you said you had. If you're doing this in query design view rather than SQL view then define a field as
there are NUMEROUS tthreads in these fora with various soloutions. Use search / advanced search. Please use htese resources BEFORE asking (new) questions. It can save both you (the original poster) and the respondents (answerers) time and effort. Further, you may often get several variations on the theme and thus a choice of approaches,
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.