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