I need help fast

[dsomers]

Need help with a report calculation

Hello all! I have 2 problems with my db program. I have a form for each problem. They're not on the same form.

1. I have a report that is serving as a Late Notice to my tenants. It has a Previous balance field, rent field, late fee field, and total due field. For some reason when I add the late fee to the tenants I select in the form, the report doesn't reflect the same values as the form does.

2. I'm using query's to calculate a new Amount Outstanding when I add court costs for those tenants I select in my form. When I select the tenant and hit Add Court Costs, it asks for a parameter from my query but I can't figure out why its asking me this because I made it almost identical to the Late Fee querys and it works.

My db is pretty big so I have it up on http://briefcase.yahoo.com. Username: davidinncsu2003 Pass: ncsuwon. Pick the mdb file with the latest date on it.

If somebody could take a look and show me how to fix this, I'd appreciate it.

Thanks!
David Somers

 

[WayneRyan]

David,

In query quryPostEvictionProceedingOutstandingUpdate:

quryPostEvictionProceedingOustanding!NewAmtOutstanding
                             ^
                             |
Did you or Access do this ---+

Wayne

 

[WayneRyan]

David,

As to the first problem, you are storing the amount outstanding
in multiple tables and they are "not in synch". The risk that you
take when you do that is someplace you do something that
affects it, yet you don't update the table.

Other than that, you're looking pretty good!

Wayne

 

[dsomers]

Thanks! When I corrected that first problem you mentioned, when I select my tenants now and try to add the court costs to the tenant, it acts likes its working, but it doesn't show up. Also my transactions table isn't reflecting a transaction was made.

Can you see whats going on with this as well?

Thanks!
David Somers

 

[dsomers]

Well I figured it out and got it working. Thanks for the typo from above.

There is another question I have, but it concerns the report for my late fee form. In the report when it lists the amounts, they are not lining up correctly. At least the dollar signs are not lining up like they should.

How do I correct this?

Thanks!
David Somers