qulaitks,
Here is your db back and working.
I have created a new table, query and report.
In your table you had Now() as the default for the Date Field. That mean that when a record is created it get "NOW" date, time (including seconds), so when you try use criteria of date it will only return the one record. Open your query and then click the date in the date field and you will see that it is not just the date, but the time- down to the second.
Also I would suggest that you don't use date as a field name, it is a reserved word in Access and if you continue to use it you will run into problems.