Access Query Issue with 2012 dates

[gtrudel]

Hi,
The attached query works with the underlying schedule setup table with 2011 dates. When I put in the 2012 dates the query does not return the correct data.
The first row has a date of 4/18/2012. Yet the query doesn't return any rows with this date. It should return 6 rows for Wk1.
Query
SELECT DISTINCTROW [Schedule Setup].Week, PLNAMES.Division, PLNAMES.Handicap, PLNAMES.Name, PLNAMES.Team, Int(Choose([Team],[1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12])) AS Expr1, [Schedule Setup].[Front/Back], [Schedule Setup].Event
FROM PLNAMES, [Schedule Setup]
WHERE (((Int(Choose([Team],[1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12])))>[team]))
ORDER BY [Schedule Setup].Week, PLNAMES.Division;

First few rows of output

Week	Division	Handicap	Name	Team	Expr2	Front/Back	Event
4/25/2012	B	16	Anthony	1	11	1	Wk 2
4/25/2012	B	20	ByeB	11	12	1	Wk 2
5/2/2012	B	16	Tom	9	10	2	$10 Tour
5/2/2012	B	24	Tim	2	3	2	$10 Tour
5/2/2012	B	21	Paul	6	7	2	$10 Tour

First data row:

Week	1	2	3	4	5	6	7	8	9	10	11	12	Front/Back	Event	CalcBonus	Closest to Pin
4/18/2012	1	2	3	4	5	6	7	8	9	10	11	12	2	Wk 1	No

[June7]

If you want to provide project so can test query with data, will look at. Follow instructions at bottom of my post.

[AccessMSSQL]

So you are missing one row. Have you checked the Team column? Is there a value there for the 4/18/2012 record. I would run your query without the WHERE clause and see what your results are. The problem may be there.