Search results

Solved... =DSum("Amount","tbl_Balance Consolidation Report (CD1460)_Updated","[Promo Indicator] = 'P'")

Thanks for the response. I don't need the date range...but when I follow the instructions on the link, I get 'Error' in the text box. However, if I take out the "Promo Indicator = P", it does sum all of the amount column in that table. =DSum("Amount","tbl_Balance Consolidation Report...

Hello all. I have a report that works great. But I wanted to add a text box that captures the total from another table because it is related to the data in the report. Table Name: [tbl_Balance Consolidation Report (CD1460)_Updated] Date Range: Between [#08/01/2012#]And[#10/31/2012#]...

Thank you sir. Worked like a charm.

Hello all. I have a report that I put together with totals at the bottom. This is a detail report that reflects [Card Number] and [Amount] so at the bottom i have a total transaction text box that works fine. I would also like to capture the total [Card Number]. However, since the same...

Thanks for responding, I appreciate it. Yes in fact there is a 'report date' that I bring in. I was excited to see your solution until i realized that in some cases, I found one, the older report date has the newer card number. So I will have to do a duplicate query and delete the closed...

Hello all. I have a graph in Excel that I created three different graphs for. Each graph is triggered by a button tied to a macro. All works great except the last one. I want it to have two Axis and it doesn't seem to be registering. Here is my code below. Thanks for your help. '...

Good morning. I have put together an import VBA that imports a text file and drops it into a table. There are 10 fields that I am importing and I have the primary key set on five fields to prevent duplicates from being imported. Everything is working fine with the exception of what I want...