Thank all of you for the help. Wayne, yours proved to be the simplest solution. Rich thank you for the catch in the “0” I have since corrected it.:D :D :D
Nowhere in my description did I mention anything about rounding down currency. The problem is when I check the house charge amount against the grand total to make sure that the house charge is less or equal, access does not seem to care that the value displayed in the grand total field is...
Here is a problem that I am having that seems very simple to me, obviously I am missing something. If some one could help?
I have a house charge field that allows a user to charge all or a portion of a bill. In the AfterUpdate event of the house_charge field is the following code. The problem...
I am trying to hide a subform based on a value within that subform. This is working fine when selecting existing records, but fails when I try to add a new record. The error states, “You have entered an expression that has no value.” The value that I am checking is from a calculated query...