Business months

[Jim]

I would like to group a report by business months. These
months end on a date other than the last date of the
month. A business month for February might be January 27 -
February 6.

I have a report of orders which includes the order date
for each order. I have a table which lists the month as
well as the beginning and end date for the business month.

How can I set up the report so that an order placed on
January 29, will show up on the February grouping.

Thanks,

Jim

 

[Duane Hookom]

Add the business month lookup table to the report's record source. Set the
criteria under the OrderDate field to:
Between [BeginDate] and [EndDate]
Make sure you add the BusinessMonth field to the grid so you can reference
it in your report.

 

[Jim]

Duane,

Thanks for the reply. I am still a bit unclear as to how
to do what you suggest.

If I put table tblBizMo into the query for the report, I
get an ambiguous outer join method as this table is not
really joined to the rest of the tables in the query.

I was thinking that I needed to base the report on
tblBizMo so that I could use the bizMo as a grouping
header, but have not found a way to put the details of
the orders for that month yet.

Suggestions are welcome and appreciated greatly.

Jim

-----Original Message-----
Add the business month lookup table to the report's record source. Set the
criteria under the OrderDate field to:
Between [BeginDate] and [EndDate]
Make sure you add the BusinessMonth field to the grid so you can reference
it in your report.

--
Duane Hookom
MS Access MVP

I would like to group a report by business months. These
months end on a date other than the last date of the
month. A business month for February might be January 27 -
February 6.

I have a report of orders which includes the order date
for each order. I have a table which lists the month as
well as the beginning and end date for the business month.

How can I set up the report so that an order placed on
January 29, will show up on the February grouping.

Thanks,

Jim

.

 

[Duane Hookom]

Save your report's current query as a saved query. Then create a new query
that uses the saved query and tblBizMo. Set up the criteria as I suggested
earlier.

--
Duane Hookom
Microsoft Access MVP

Duane,

Thanks for the reply. I am still a bit unclear as to how
to do what you suggest.

If I put table tblBizMo into the query for the report, I
get an ambiguous outer join method as this table is not
really joined to the rest of the tables in the query.

I was thinking that I needed to base the report on
tblBizMo so that I could use the bizMo as a grouping
header, but have not found a way to put the details of
the orders for that month yet.

Suggestions are welcome and appreciated greatly.

Jim

-----Original Message-----
Add the business month lookup table to the report's record source. Set the
criteria under the OrderDate field to:
Between [BeginDate] and [EndDate]
Make sure you add the BusinessMonth field to the grid so you can reference
it in your report.

--
Duane Hookom
MS Access MVP

I would like to group a report by business months. These
months end on a date other than the last date of the
month. A business month for February might be January 27 -
February 6.

I have a report of orders which includes the order date
for each order. I have a table which lists the month as
well as the beginning and end date for the business month.

How can I set up the report so that an order placed on
January 29, will show up on the February grouping.

Thanks,

Jim

.