hello all.

 

I am trying to find out the right way to find totals of retail dollars by specific departments or sales staff.   so in my mind i think...   Get retail if dept="A".  or Get retail if sales="debbie".   and what i would want would be a total of all retail dollars for all entries that that department or sales person equals.

 

 

make sense?

It would help to know more about your table structure and relationships. Have you checked out summaries and sub-summaries?

what i would want would be a total of all retail dollars for all entries that that department or sales person equals.

 

Use a summary field and place it in a sub-summary part (or sub-summary parts). When your records are sorted by the field associated with the sub-summary part, the summary field will show the corresponding sub-summary value for each group of records.