Moises,

In addition to what George said, some people store a "Fiscal Period" rather than storing a date. We use something like 200101 which is an integer. It would be pretty easy to go from a receipt date to the fiscalperiod with something like

VAL(LEFT(DTOS(dMyDate), 6)) or YEAR(MyDate) * 100 + Month(MyDate).

That way in your reporting you only have to group on FiscalPeriod.

If the fiscal year starts in July, as some American companies do, you can call the period "CalendarPeriod" and have a table that maps fiscal to calendar periods.

>To control money amount per month at a shop,
>
> Whats programatically more correct and usual
>
> Create only a table to control all months
>
> Or create a new table every month ?
>
> Jan_2001.dbf
> Feb_2001.dbf
> etc...
>
>
> I've never created this kind of application before
>
> Thanks
>
>
>
>
>
>