Only show current records?

[pixiedust]

I have a database based on fiscal years: i.e. 2007/2008 2008/2009 etc.

Is there a way to only see the current fiscal (2008/2009) and make the prior fiscal years hidden (invisible)? The field is a text box to house the fiscal years.

Thanks!

Pixie

[missinglinq]

How does your fiscal year run? What fiscal year, using your criteria, would today be part of?

Linq ;0)>

[NeoPa]

We also need the record layout of the table you're selecting from or maybe the current SQL of the existing query would do.

How is the control on the form set up? Is it a ComboBox or TextBox or what?

These we need to know if we're to help.

[FishVal]

As for criteria for fiscal year, there are a bunch of threads in the forum concerning the same issue.

Fiscal YTD vs. past year in Query criteria
Fiscal Year
even more Fiscal Year
MS Access VBA - Dates

Regards,
Fish