Business months

  • Thread starter Thread starter Jim
  • Start date Start date
J

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
 
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,

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
Click to expand...


.
Click to expand...
 
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


Jim said:
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
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top