Custom Grouping?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good Day All,

I have a report that I am creating for my inventory that is currently
grouped by "ordertype" which can include Custom, Program, or Sample.

I want to group by this Ordertype, but I want a group of the Custom
inventory types, and a group by the Program & Sample inventory types.

How do I set that up? Does it need to be done within the query the report
is based upon?

Thanks in advance..

Brook
 
One method is to create a sorting or grouping level in your report like:
=(OrderType = "Program" Or OrderType ="Sample")

Ideally there would be a field created in your order type lookup table that
would identify the grouping.
 
Thanks Duane,

That was perfect, I never realized that the "Sorting/Grouping" could be
custom coded like that.

you have been a tremendous help both today and in the past!

Thanks..

Brook
 
Glad to help...

--
Duane Hookom
MS Access MVP


Brook said:
Thanks Duane,

That was perfect, I never realized that the "Sorting/Grouping" could be
custom coded like that.

you have been a tremendous help both today and in the past!

Thanks..

Brook
Click to expand...
 
Back
Top