I'm afraid i am at a loss how to do this from your examples, and the Between
operator seems to just evaluate if a date falls in a range, whereas i need to
produce a list of each day in the range...have i misunderstood your
directions? Would you clarify the proper syntax for the query?
Lost in query land,
Billiam
Stefan Hoffmann said:
hi Billiam,
I am planning on using unbound comboboxes for the cboDateFrom and
cboDateTo...will this still work, or do i have to have an underlying table of
dates?
I'm afraid i am at a loss how to do this from your examples, and the Between
operator seems to just evaluate if a date falls in a range, whereas i need to
produce a list of each day in the range...have i misunderstood your
directions?
So you have to dates and would get a list - as a query - of days between
them?
In this case you need a additional table holding the numbers from 1 to
365. Basically it must look like this:
SELECT DateAdd("d", T.number, T.number)
FROM numberTable T
WHERE DateAdd(minDate, T.number) <= maxDate
mfG
--> stefan <--
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.