report - Filtering dates in Access queries? -


i'm building report client. report not complicated, shows bunch of stuff requested clients. 1 of things i'm stuck on is... need able search transaction took place between today , 6 months back. when user click on transaction report, shows last 6 months today. have idea? i'm trying build query criteria, have no idea how should be.

another part of report lets client choose dates report (from & to) , that's not bad because i'm passing these values blank form , using them in report. however, here i'm having hard time figuring out.

=dateadd("m", -6, date()) fulfills requirements in application


Comments

Popular posts from this blog

Capture and play voice with Asterisk ARI -

visual studio - Installing Packages through Nuget - "Central Directory corrupt" -

java - Why database contraints in HSQLDB are only checked during a commit when using transactions in Hibernate? -