This is probably a simple question but one that is alluding me, i have a report but i want to add some totals from another table.
The report already has simple control source items like =Count(IIf([LocationShort]="A101",0)) but i want to count other items in a different table
using the same method????