Limiting records for subtotal

[Linda]

I am attempting to come up with a report, based on a query, that would limit
the records returned to being unique.

I only have 4 fields in the query -
Primary Key (because this is imported from an oracle database, it is not
unique. If there are additional location fields, the key repeats)
State - only 8 states in the query
Quantity - acres (this again comes from the oracle databse and the number
repeats, based on the primary key, when there are location changes). This is
the field I want to subtotal by State, only taking into account one quantity
per Primary Key.
Interest type - I have limited this in the query criteria Not Like "lease"
so leases aren't counted.

I am fighting a wicked head cold and just can't seem to figure this out!

 

[Bernie]

I am attempting to come up with a report, based on a query, that would limit
the records returned to being unique.

I only have 4 fields in the query -
Primary Key (because this is imported from an oracle database, it is not
unique. If there are additional location fields, the key repeats)
State - only 8 states in the query
Quantity - acres (this again comes from the oracle databse and the number
repeats, based on the primary key, when there are location changes). This is
the field I want to subtotal by State, only taking into account one quantity
per Primary Key.
Interest type - I have limited this in the query criteria Not Like "lease"
so leases aren't counted.

I am fighting a wicked head cold and just can't seem to figure this out!

Extract the data from the oracle database server then create queries in
access using unique types. By doing so, you only have unique values in your
query and then use this data for your report.