keep hitting blockers on this.
I have a report requiring a select statement with aggregation and conditions for each report field/control (not sure of the nomenclature here).
First I tried the select statement in one query object. However, I keep hitting blockers with the limitations of sql in ms access object. Then tried query design mode next...also a bust. Finally figured out I can use subquery controls in an unbound report but designing the layout sucks.
How would an expert go about completing this report? (db structure and report design below)
Example data from tblBrokerageLog
I have a report requiring a select statement with aggregation and conditions for each report field/control (not sure of the nomenclature here).
First I tried the select statement in one query object. However, I keep hitting blockers with the limitations of sql in ms access object. Then tried query design mode next...also a bust. Finally figured out I can use subquery controls in an unbound report but designing the layout sucks.
How would an expert go about completing this report? (db structure and report design below)
Code:
Table: tblBrokerageLog
| Field Name | Data Type |
|------------------------|-----------|
| DATE_P1 | date/time |
| SUPPLIER | text |
| MATERIAL | text |
| RECY_PO | text |
| ALLIED_REP | text |
| CONTAINER_ID | text |
| ETD | date/time |
| ETA | date/time |
| RECY_SETTLEMENT_NUM | nuber |
| RECY_SETTLEMENT_AMOUNT | number |
| RECY_DATE_SETTLED | date/time |
| BUYER | text |
| RECY_SO | text |
| BROKER | text |
| COMMISSION | number |
| ALLIED_INVOICE_NUM | number |
| ALLIED_SOLD_AMOUNT | number |
| ALLIED_INVOICE_DATE | date/time |
| SHIPPERS_FACT_NUM | text |
| BL_or_COO_FINAL_DATE | date/time |
| DESTINATION | text |
| IS_COMPLETE | text |
Example data from tblBrokerageLog
Attachments
Last edited: