M
Michael N
I have a table of data that has a StartDate. I am trying to assign a Number
that represents the Fiscal Period the startDate Falls into.
I have another table that lists the FiscalStartDate, FiscalEndDate and
PeriodNumber:
09/26/2004 (FiscalStartDate)
10/23/2004 (FiscalEndDate)
1 (PeriodNumber)
In the first table a StartDate of 09/27/2004 falls between 09/26/2004 and
10/23/2004. Therefore the PeriodNumber is 1. I am trying to create a query
or expression to get the PeriodNumber assigned to each record on the first
table.
I am sure this is easy, but I am strugling with it at the moment. Any Ideas?
that represents the Fiscal Period the startDate Falls into.
I have another table that lists the FiscalStartDate, FiscalEndDate and
PeriodNumber:
09/26/2004 (FiscalStartDate)
10/23/2004 (FiscalEndDate)
1 (PeriodNumber)
In the first table a StartDate of 09/27/2004 falls between 09/26/2004 and
10/23/2004. Therefore the PeriodNumber is 1. I am trying to create a query
or expression to get the PeriodNumber assigned to each record on the first
table.
I am sure this is easy, but I am strugling with it at the moment. Any Ideas?