Search results

The total you are seeing is not related to my sub form. It's a one to many set up.

what would that query look like? This is what I have on my form at this point =[INVOICE RECONCILATION_TBL Subform].[Form]![REC AMT]

I have a sub total on a form that I'd like capture in my master table. Is there a simple way to do this? It's the Total Received field which is a running calculation based on the sub form Invoice Reconciliation if that helps. There could be multiple transactions related to one invoice.

Sorry, I was testing your sample and then got pulled away for another project. That being said, Yes you did indicate the draw back being it would only work with 2. I do however need it to work if there is only 1 or 2.

Yes, Yes, it works perfectly and actually your method is more of what I wanted. Simplified, however it does only work if there are 2 General Withdrawal. If I remove the 1st one from the orig. file and those records before leaving on one it removes the one remaining Withdrawal record, but not...

Thank you.

thank you.

This works perfectly regardless of there being a General Withdraw or not. Thank you.

Okay, I initiate the General withdraw manually on a by weekly bases. It is not an auto process. That being said there could be sales prior to me withdrawing the funds that are captured in the prior General Withdraw and already accounted for hence me omitting and the same for the end Withdraw...

That is the data. I'm confused with your question? I literally go out to PayPal enter a to/from date and that is the data I receive with the exception of omitting/masking the name of those who purchased. It comes in a text file that I link to MS Access and export what I need. There is other...

Sorry, I didn't realize I could attach an excel file. Here you go. Thanks.

Attached is a payment file that I need help with please. Data is retrieved via a to/from date. In this case its from 09/03/2021 to 09/15/2021. I do this on a bi-weekly bases. What I need to do is eliminate the General Withdrawal record if one exists at the beginning of my date range along...

Your right. I guess i'm reading into this to much, but basically if there is an ID in the [transaction ID] field and in (Payflow Tranaction ID(PNREF) field then update [New Field} with [Gross] field otherwise "0.00". Transaction ID Payflow Transaction ID (PNREF) Gross NEW FIELD...

Thank you for taking a look at this. Hopefully below will clarify. A=True, B=True, Result=B (B SHOULD OVERRIDE A IF B is = TO (PNREF) A=True, B=False, Result=A A=False, B=True, Result=B A=False, B=False, Result=A (BUT THIS SHOULD NEVER OCCUR)

How do I combined the 2 expressions below? Ultimately, I want the 2nd part to override the 1st if applicable. GROSS AMT1: IIf([Transaction ID],[Gross],"") BUT or however IIf([Payflow Transaction ID (PNREF)],"",[Gross])

TABLE 0,1 "BIN" VECTORS 0,4.000000 "" TUPLES 0,0000055 "" DATA 0,0 "" -1,0 BOT 1,0 "00885532555" 1,0 "001" 1,0 "09A01" 1,0 "OUT RC CONVERTER KIT" -1,0 BOT 1,0

its a ASCII text

I'm attempting to initiate a combine power query from a folder with several .DIF files. Each file should have the same layout with 3 columns of data. That being said when attempting to combined all the data pulls into one column. I'm new to this, so I'm not sure what it is i'm doing wrong...