[MS_AccessPros] How to total a fiel base on another field

 

Good morning every one.

 

I have a question, I wonder if someone can help me.

 

1. I have table that shows in a Colum a commission amount.

 

2. Another Colum shows the date it was paid, if it has not been paid it has not date (it is null)

 

I have a report, and at the bottom, I will like to show the total for the transactions that have been paid and the total for the ones that have not been paid.

 

How do I go about this task?

 

Thank you very much for the help, this group has always been good to me!!

 

Jorge Muralles

 

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___