I have a relational database. I am running a query that does a few things.
1. It shows the unique identifier for the record.
2. It then performs a DateDiff from StartDate to CloseDate
3. It looks at the dollar amount from the record and multiplies it by the calculation (.06/365) and the DateDiff.
The last step allows me to apply an interest fee from the open date and the close date.
I have another form that let me do a recordset and apply a service fee from the beginning based on a code. It would populate a text box with the fee which would write it to the table.
The question:
I have a CloseCB form that has 6 parts.
1. DateClosed - AutoDate – The date of closing
2. SeqNo – Unique identifier for each record
3. AC – Type of closing
4. Comment
5. InterestFee
The date is automaticly put in when you start to close the item.
I need to have the InterestFee to populate with the outcome of the query above. I was thinking to have a SQL string from the query but I can not seem to get it to work.
The reason I need it to populate in the text box is so it will write into the table and I will have history. We will be changing our interest rate over time and I need to know what I charged today as opposed to 6 months from now.
Thanks,
Please let me know if I gave enough info this time.
1. It shows the unique identifier for the record.
2. It then performs a DateDiff from StartDate to CloseDate
3. It looks at the dollar amount from the record and multiplies it by the calculation (.06/365) and the DateDiff.
The last step allows me to apply an interest fee from the open date and the close date.
I have another form that let me do a recordset and apply a service fee from the beginning based on a code. It would populate a text box with the fee which would write it to the table.
The question:
I have a CloseCB form that has 6 parts.
1. DateClosed - AutoDate – The date of closing
2. SeqNo – Unique identifier for each record
3. AC – Type of closing
4. Comment
5. InterestFee
The date is automaticly put in when you start to close the item.
I need to have the InterestFee to populate with the outcome of the query above. I was thinking to have a SQL string from the query but I can not seem to get it to work.
The reason I need it to populate in the text box is so it will write into the table and I will have history. We will be changing our interest rate over time and I need to know what I charged today as opposed to 6 months from now.
Thanks,
Please let me know if I gave enough info this time.
