Query using date from form and subtracting 1 day

[Risto85]

Hello



I have a query that reads the date criteria from user form. I use formula

Like [forms]![Userform].[Date1] & "*"

. So when user inputs 14.03.2015 then query displays everything with criteria 14.03.2015. I would like to query do display everything from day before. So in this example case query should display everything with date criteria 13.03.2015

[orange]

If the criteria is not correct, then change the criteria.
You have to determine exactly WHAT the condition/criteria is and then code it and test the query appropriately.
You may want to research the DateAdd function (to subtract 1 day from a Date value).
Good luck.

[JoeM]

How about:

[Forms]![Userform].[Date1] - 1

[Risto85]

Orange, got it working using dateadd function
JoeM, thank you for providing idea , but unfortunately it displayed query empty.