Search results for query: *

Thanks for the advice MichaelRed. I was wondering do you have any ideas on how I can make a calculating button with what you have said above. I am not to adapt to the method you are talking about, if you could explain it that would be great. Thanks for the help.

Hey Chubby,JasonZ here. I tried what you said, but unfortunately I got an error message that states "Cannot have aggregate function in ORDER BY clause (Sum([Check_Amount])). Well anyway, if you could please help me with this problem. I would like to do totals for this field and another...

Hey, thanks Terry for the advice. Unfortunately it doesn't work still. I did exactly what you said and used the values that you typed above. I ran the macro and it still only adds to the left of the decimal.(whole numbers) and ignores the cents all together now. Before, when it was on currency...

Hello I have a simple question I hope. I need to make a calculate button work. Here is the information I have so far: In my Macro I have ([Forms]![Status of Payment]![Check Amount:]) in the item part and ([Forms]![Status of Payment]![Check Amount:]+[Forms]![Status of Payment]![Text132]) in the...

Here is the situation: There is a Status_of_Payment table that includes a field called check_amount; which spits out currency values. Well I made a query with a couple fields in it and one of them was like this "Monthlybill: Sum(([Check_Amount]*0.07)) Well this is a really nice query...

I found this answer in the forum, but I don't understand how to make the control button: Here is the information I found: To provide this functionality in Access, attach this Event Procedure to the KeyPress event of your control. Select Case KeyAscii Case 43 ' Plus key...

I have a question regarding making a button in my form that could pull from the "case#" field and show me a box to just enter in the case# and press ok and then pull the record that has that case# I specified. (like a parameter). Basically I have two Forms "STatusDos" and...