Search results

Pat, I believe I have a better way to count my fees owed. I now have a control that counts records. I have a control on my main form that has a begin date. If I change my record count control to the following I could enter as many payments as I wanted without them being counted as billing...

Perhaps I should have posted this in the queries forum as I am guessing I really want to write an expression for an update query.

Hello, I hope the following will explain my dilema. I want to have a calculated control on my form to provide an event date in the future. I already have two types of events that I project a "next event" by using update queries ran by a macro button on the form for updating. Heres the flow of...

Pat thanks. I had already tried =Sum(YourFieldName) in the form footer area and could not get it to work. I realized today quite by accident that my subform showing my billing was in datasheet view and doesn't show the form footer. I don't know if I am able to see it somehow. It doesn't...

Thanks again for your input. I have considered tabbing my form. However, I use this to go to court with. My clients appear before the court every other week. I need the information available at a quick glance and was afraid that tabbing forms my get me confused. The Judge only spends a few...

Attaching screen shot of bottom part of client form to further help explain

Attaching scrn shot top of my Client form to help explain what I am using it for

Pat, I work for a government agency. We do not normally bill our clients. We are required to track their fees and simply send form letters if they get delinquent or direct them verbally to pay. That's why I need to know how to do caculated controls or totals either on a main form or my...

Pat, I figured out adding my second payment set. If I don't enter any values, the report is blank. That will work for me. Counts both sets now. Perhaps this is a FORMS question, but can you tell me how to do the calculated controls to post to my main forms on each client the total paid and...

Pat thankyou very much. I added a text box in my group footer. (You know, I borrowed this report format from another and attempted to change it to meet my needs. I don't know how to add a group footer.) Now for part two of my several continuing questions. All of my clients pay 40/mo. Some...

Totally in over my head here. I have client management type data base. I am attempting to track their accruing fees to me. I have created a sub form along with a financial table. Any input from any client record goes into this financial table as primay key, date, payment amount. My set fee is...