Query Data Criteria

M

Mike

I am attempting to create a query that counts, and sums. The query
basically counts the number of occurances, and sums total points. I
am trying to make the query sum total points from the past two years
ONLY based on a "now()" date. The query will NOT execute. Any help
is appreciated.
 
J

John W. Vinson

I am attempting to create a query that counts, and sums. The query
basically counts the number of occurances, and sums total points. I
am trying to make the query sum total points from the past two years
ONLY based on a "now()" date. The query will NOT execute. Any help
is appreciated.
Click to expand...

Use a criterion of
= DateAdd("yyyy", -2, Date())
Click to expand...

on the date field that I presume you have.

Note that we have NO way to even guess what's wrong with your query. Care to
post the SQL view, and indicate in what way it doesn't work?

John W. Vinson [MVP]
 
M

Mike

Use a criterion of


on the date field that I presume you have.

Note that we have NO way to even guess what's wrong with your query. Care to
post the SQL view, and indicate in what way it doesn't work?

John W. Vinson [MVP]
Click to expand...

John,

Thanks, that worked perfectly...

Mike
 
Top