I'm trying to design a report based on the financial year eg 1/7/1999 to 30/06/1999 using records from Access database. The user will be prompt to enter a date eg 20/03/2000 and it will then pick up all items from 1/7/1999 to this date.

What is the best report designer to use to do this, VB report designer or Crystal reports. Is there a function that you can use to calculate this range.

Thanks in advance