Help with Query Criteria

[slan110]

Hello! 

I have a query where users are entering two dates [Enter Start Transaction Date] and [Enter End Transaction Date]. I am trying to create a subquery that will use [Enter Start Transaction Date] and look back 5 days to capture anything in that timeframe. 

I'm trying this (unsuccessfully): Between [Enter Start Transaction Date]-5 And [Enter Start Transaction Date]

Have also tried this: Between ([Enter Start Transaction Date]-5) And [Enter Start Transaction Date]

This is the error I get: 

Is this even possible? And if so, how can I achieve this? Thank you!

[#2]

See if it improves if
[Enter Start Transaction Date]
is a Parameter of type DateTime in your query. While in query design view, find the Parameters form on the Ribbon.

[#3 · Accepted solution]

I actually able to use a formula like : Between DateAdd("d",-5,[Enter Date]) And [Enter Date] and it worked perfectly!