1. that shouldn't work. Please post the query.
2. When you created the column named "Date", Access told you not to but you ignored the warning. You will have trouble in code modules unless you change the column name to be NOT a function name and NOT a property name. embedded spaces and special characters are poor practice but you can usually get by with them except they will also cause strange situations in code under certain circumstances.
Look at the example in this database to see what happens when you name your columns using the two worst offenders - Name and Date.