rjbinney
Active Member
- Joined
- Dec 20, 2010
- Messages
- 279
- Office Version
- 365
- Platform
- Windows
It has been years since I've used Access, so please forgive the beginner question.
I have two reports in Excel.
One lists:
Each customer (therefore each Customer Number) has multiple orders. Each row is an order.
Example:
<tbody>
</tbody>
The other lists
<tbody>
</tbody>
I'd love a "Customer on a Page" report, listing Customer Number, Sales Manager, a list of all sales orders, and a list of all authorized-signatures. For example:
Cus-001 (Ringo)
SO 564
Pete T
Roger D
--- new page ---
Cus-002 (Paul)
SO 828
SO 912
Alan L
Derek L
Gordon C
--- new page ---
Cus-003 (George)
SO-231
Bruce S
--- new page ---
Cus-004 (Ringo)
SO-310
Jack B
Eric C
Ginger B
I remember to import the tables, and create a query to connect the "Customer Number" on one to the other.
Then I forget everything I ever learned about Access.
BUt I can do this, yes?
Thanks
I have two reports in Excel.
One lists:
- Customer Number
- Sales Manager
- Order Number
Each customer (therefore each Customer Number) has multiple orders. Each row is an order.
Example:
CUSTOMER | SALES MANAGER | ORDER |
Cus-0001 | Ringo | SO-564 |
Cus-0002 | Paul | SO-828 |
Cus-0002 | Paul | SO-912 |
Cus-0003 | George | SO-231 |
Cus-0004 | Ringo | SO-310 |
<tbody>
</tbody>
The other lists
- Customer Number
- Authorized-to-Order
CUSTOMER | AUTHORIZED-to-ORDER |
Cus-001 | Pete T |
Cus-001 | Roger D |
Cus-002 | Alan L |
Cus-002 | Derek L |
Cus-002 | Gordon C |
Cus-003 | Bruce S |
Cus-004 | Jack B |
Cus-004 | Eric C |
Cus-004 | Ginger B |
<tbody>
</tbody>
I'd love a "Customer on a Page" report, listing Customer Number, Sales Manager, a list of all sales orders, and a list of all authorized-signatures. For example:
Cus-001 (Ringo)
SO 564
Pete T
Roger D
--- new page ---
Cus-002 (Paul)
SO 828
SO 912
Alan L
Derek L
Gordon C
--- new page ---
Cus-003 (George)
SO-231
Bruce S
--- new page ---
Cus-004 (Ringo)
SO-310
Jack B
Eric C
Ginger B
I remember to import the tables, and create a query to connect the "Customer Number" on one to the other.
Then I forget everything I ever learned about Access.
BUt I can do this, yes?
Thanks