Search results

Thanks. I don't think I explained what I needed to well. But I actually found a solution. I just ran another query from my original make-table query. and put an if statement in my Field Name. COD Amount: Sum(IIf([payment_form] Like "D",[Sumofaih_sub_payment])) This ultimately helped me...

Hello Everyone, I have a little problem with a query and was wondering if this could be done. I have a field entitled Payment form. In this field there can be 5 different things. 0 for Null, C for Card, D for Cod, E for E-check, and W for Wbill. I have another field entitled Sub Payment...

Okay, I got a little further and the Eval does what it is supposed to do. Now I have a couple more problems. The way I have it set up is that I have two textboxes One will eventually be hidden. My first textbox is not linked to any field in my table it is named(Line_Item_Cost_Faketxt) my...

Thanks alot It took me awhile, but now I get it. Nz is a function that returns 0 or defined value if is field is null. I am learning. Now I can show everyone at work, but they get a little thrown back when it comes to VBA Matt

Private Sub MyTextBox_AfterUpdate() Me.MyTextBox = Eval(Nz(Me.MyTextBox, 0)) End Sub I do not want to be a pain, but please bare with me. Okay. In place of "MyTextBox" I would put the name of the Textbox that I wish to do this eval in. "Me" is the name of the form? or table? I am unsure...

I don't really understand what is being done here with eval. I mean do I put eval and then an equation in the before update field. ex. eval(1+1+1) could you give me a working example that I could go from.

Hello everyone: This is my first post on this website. I am a beginner to intermediate user in Access And right now I am trying to create a data entry form, however I need my fields to do Addition. I want to be able to type +2+6+5 in my field and it show the answer. Just like in excel. I...