>Hi Cindy,
>
>Given that I deal a lot with fiscal months and years, I should've caught this possibility. In these situations, what I do is have a table containing the month name, and the starting and stopping dates for the period. I then use a query utilizing BETWEEN to retrieve the applicable information. Since I still need the date field, this allows me to utilize that, rather than having to populate an additional field.

George,

Some of my data comes in with the FiscalPeriod assigned already, so I'm more likely to use that than derive it from a date. The actual date is only of secondary importance for me.

In any case, this will give Moises some ideas for his design.