Query Date Range From Single Date

[MaxQTime]

Is it possible to query a range of dates starting with a single date? I want to be able to put in a date, and get that date plus the next 5 days as an example. I know how to set up a between query for dates, that's not quite what I want to do though.



I know the answer is probably pretty simple, but I can not seem to find the answer through google.

[Micron]

I know how to set up a between query for dates, that's not quite what I want to do though.

Then what exactly?
Where does the input come from? Is this vba sql because it's not a query?

Trying to understand why this isn't just BETWEEN [INPUT DATE] AND ([INPUT DATE] + 5)? (although I realize that would be 2 prompts if it were a parameterized query)

[MaxQTime]

That's exactly what I want to do, BETWEEN [Input Date] and [ Input Date +5]. I'm not sure about that syntax for the +5 days though.

I will probably be getting the input from a text box on a form though. That way I could set it up with a calendar control. Or just set up a calendar control, I'm not quite sure about how that works yet though.

[Micron]

I still don't know what you want to achieve or where you want to use some sort of expression - just what you seem to not want

I know how to set up a between query for dates, that's not quite what I want to do though.

BETWEEN Forms!txtDate AND Forms!txtDate + 5? But where?? vba sql? Query calculated field? query criteria?

Maybe it is Windows Regional Settings driven, but Date + 5 gives me 6/02/19 in immediate window on 05/28

[MaxQTime]

That's exactly what I want, I just didn't think it was as simple as adding a +5 to it.

It will probably be part of a query criteria.

[June7]

I tried

BETWEEN [INPUT DATE] AND ([INPUT DATE] + 5)

it errors "... too complex …"

Same with

Between [Forms]![Form1]![txtItemSearch] And [Forms]![Form1]![txtItemSearch]+5

This does work

Between [Forms]![Form1]![txtItemSearch] And DateAdd("D",5,[Forms]![Form1]![txtItemSearch])

In many cases, it is possible to just +5, day unit is default in arithmetic with dates, but apparently WHERE clause is persnickety.

[Micron]

Thanks for that. Seems like the message ought to be more along the lines of "circular reference" because it would seem like that is what's going on. However, I see that
Between [input] And DateAdd("d",30,[input])
also works.

and there's only one prompt.