Query Data Criteria

[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.

 

[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.

Use a criterion of

= DateAdd("yyyy", -2, Date())

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]

 

[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]

John,

Thanks, that worked perfectly...

Mike