Grouping on Report

[jgkaufman via AccessMonster.com]

I have a report that I want to have grouped in the following format:

Item Number
Purchase Order#
Purchase Order#
etc....
Sales Order#
Sales Order#
etc.

I was able to do this with just the purchase order, but when I needed to see
all the Sales Orders for each item number, the report lists as following:

Item Number
Sales Order# 1
Purchase Order#
etc.
Sales Order# 2
Purchase Order#
etc.
etc...


Thanks for any assistance ya'll can lend

Jason

 

[Duane Hookom]

You could try create a subreport of all the PurchaseOrderNumbers with the
Item Number. Add this subreport into the Item Number header section and
remove the Purchase order from the sorting and grouping levels.

 

[Jason Kaufman via AccessMonster.com]

Forgive my denseness...but i dont know about subreports, i usually create
queries from tables and then reports from those queries and subsequent tables.
Do you mean a subreport = query or is that something else all together?
While i think myself somewhat proficient in acccess i havent heard of
subreports, of course i dont mind learning something new.
However, if i were to create a subreport for the POs and put it on Item
Number header, would that only present 1 PO# for each item #? I tried that
with the fields i have now and it worked that way, thus not showing the
subsequent PO#s. But I will try and also remove the PO from the
sorting/grouping level

You could try create a subreport of all the PurchaseOrderNumbers with the
Item Number. Add this subreport into the Item Number header section and
remove the Purchase order from the sorting and grouping levels.

I have a report that I want to have grouped in the following format:

[quoted text clipped - 22 lines]

Jason

 

[Jason Kaufman via AccessMonster.com]

I have since looked up subreports and lo and behold I have learned something
new tonight! lol, I shall have to play with this and see what happens...it
seems it work after all, i'll you know tomorrow.
Thank u very much for your help!

Forgive my denseness...but i dont know about subreports, i usually create
queries from tables and then reports from those queries and subsequent tables.
Do you mean a subreport = query or is that something else all together?
While i think myself somewhat proficient in acccess i havent heard of
subreports, of course i dont mind learning something new.
However, if i were to create a subreport for the POs and put it on Item
Number header, would that only present 1 PO# for each item #? I tried that
with the fields i have now and it worked that way, thus not showing the
subsequent PO#s. But I will try and also remove the PO from the
sorting/grouping level

You could try create a subreport of all the PurchaseOrderNumbers with the
Item Number. Add this subreport into the Item Number header section and

[quoted text clipped - 5 lines]

 

[Jason Kaufman via AccessMonster.com]

This worked great...thanks!

I have since looked up subreports and lo and behold I have learned something
new tonight! lol, I shall have to play with this and see what happens...it
seems it work after all, i'll you know tomorrow.
Thank u very much for your help!

Forgive my denseness...but i dont know about subreports, i usually create
queries from tables and then reports from those queries and subsequent tables.

[quoted text clipped - 12 lines]

 

[Duane Hookom]

Glad to hear this worked for you.

--
Duane Hookom
MS Access MVP

This worked great...thanks!

I have since looked up subreports and lo and behold I have learned
something
new tonight! lol, I shall have to play with this and see what
happens...it
seems it work after all, i'll you know tomorrow.
Thank u very much for your help!

Forgive my denseness...but i dont know about subreports, i usually create
queries from tables and then reports from those queries and subsequent
tables.

[quoted text clipped - 12 lines]

Jason