excluding specific data

[EmAlbritton via AccessMonster.com]

Afternoon all.

I need a bit of assistance...I hope it is something simple.

My database is tracking drug testing. It includes all the pertinent
information for a particular call to perform a drug test as well as all the
donors involved.

In certain circumstances, the first donor is included in the standard fee,
and all the additional donors are charged extra.

My report is working for charging the standard fee, and the extra fees for
each donor. I am unsure of how to "exclude" the first donor (show the charge
as 0) and only charge the extra fees for the subsequent donors.

My table structure is such that the donors are in a separate table linked to
the main call table through the MainTable Record ID (PK) which is FK in the
donor table.

Any assistance would be greatly appreciated. Will post additional info if it
will give more insight and help with pointing me in the right direction.

Thanks,
EA

 

[Damian S]

Hi EA,

A simple way would be to have your query work out the total fee for the
number of donors minus 1 (as that one is included with the standard fee).

Damian.