Pulling Dates from More than One Year

[Bonediggler]

Hello--

I am building a very simple report which pulls a couple of metrics by date from an Access table. The date range in question is basically 09/01/2007 - 02/12/2008.

For some reason, the report will not pull anything from 2008. When I specifically state in the select expert that the report should only pull dates greater than 12/31/2007, nothing populates.

The data is there in the table.

Thanks in advance for your help.

 

[lbass]

Try verifying the database (database->verify database).

-LB

 

[Bonediggler]

Thank you lbass.

Needed to change to left outer joins between tables as not all records matched.

Thanks again.