A Ashley Jun 11, 2004 #1 How can I get the beginning and ending date to show up in the query? Between Date() And DateAdd("m",-1,Date()) Please help!
How can I get the beginning and ending date to show up in the query? Between Date() And DateAdd("m",-1,Date()) Please help!
R Rick B Jun 11, 2004 #2 try something more like... = DateAdd("m",-1,Date()) and <=Date() Click to expand... Rick B How can I get the beginning and ending date to show up in the query? Between Date() And DateAdd("m",-1,Date()) Please help!
try something more like... = DateAdd("m",-1,Date()) and <=Date() Click to expand... Rick B How can I get the beginning and ending date to show up in the query? Between Date() And DateAdd("m",-1,Date()) Please help!
K Ken Snell Jun 11, 2004 #3 You want the query records to include the Date() and DateAdd("m",-1,Date()) values? Just add two calculated fields to the query: TodayDate: Date() LastMonth: DateAdd("m",-1,Date())
You want the query records to include the Date() and DateAdd("m",-1,Date()) values? Just add two calculated fields to the query: TodayDate: Date() LastMonth: DateAdd("m",-1,Date())
