Fiscal Year (1 Viewer)

[asp_learner]

I am trying to do a report by Fiscal Year. If a date of employment starts during a fiscal year it it will know the Fiscal Year to choose from. The dates for my company vary from year to year. I know I could do this with an IIf statement but would like to know if there is a way to tie it to a Fiscal Year table instead so that my successor wouldn't have to change the IIf statement every year.

Thanks,
Eva

 

[asp_learner]

I just answered my own question. I made a query with two unlinked tables, one with the fiscal year dates and the other with the employment dates and in the criteria for employment date I used between [Start Date] and [EndDate].