Access Report Query Challenge

[Freefall27]

I am building an Access 2000 report and need to show a grouping of records. The records come from a join of three tables. I am trying to isolate certain records that do not appear in the table.

Example:

Table – Segment Attributes

Name Category Vendor Status Attribute Group Attribute Value
17.BGCRY.NC LEASE ACR PENDING NETWORK COST BTN 9811234
17.BGCRY.NC LEASE ACR PENDING NETWORK COST ACCT 5582

This record has actual network cost values (2 records) and still displays on report below. The other two below have no network cost values and should be on report since total would equal “0”

Report Layout – Current Output

Name NetCost Category Status Inst ID
12.AVBGR.NC 0 LEASE PENDING 9001
15.CFGNP.NC 0 LEASE PENDING 9001
17.BGCRY.NC 0 LEASE PENDING 9001


Report Layout – Desired Output

Name NetCost Category Status Inst ID
12.AVBGR.NC 0 LEASE PENDING 9001
15.CFGNP.NC 0 LEASE PENDING 9001



Table - Segment Attributes
Field - Attribute Group

I created a field called NetCost and input the following formula:

NetCost: IIf([SEGMENT_ATTRIBUTES].[ATTRIBUTE_GROUP]="Network Cost",1,0)

Criteria = 0

 

[Remou]

Why not use a query to select only those records that do not appear in the table (find unmatched query wizard) and build your report on that?