Recent content by chip0105

Vlad, Sorry it has take so long to get back to you. After discussing with my User, I checked/unchecked some of the field selections very easily using the template process in your design and it works exactly as I needed it to. Thank you VERY much for all your assistance. It is GREATLY...

We currently have Monarch (a way old version; v7). However, our future state will no longer have Monarch to use. This would have taken me less than 5 minutes to set it up using Monarch. However, that will not be an option moving forward.

My apologies. Please see a modified copy of my sample data that I am working with.

I have a Report file exported to text that contains numerous rows of information that will not be used. When the data is imported, it all gets dropped into Field1 in my table as the exported data does not have any reliable delimiters. In the middle of a record line I have a field I can collect...

If there are multiple Transactions making up the sum of the Opening Balance, each individual Transaction would need to be Aged.

Also, if a Transaction is part of the Opening Balance and is still open/unresolved and ends up as part of the Closing Balance, the Aging should reflect the number of days that specific Transaction has Aged.

If VBA code would be easier to work through this process, then I am all for it. I am not locked down to creating this through the use of basic query structures by any means. After speaking with the Manager, I modified the Excel sample spreadsheet to show how and what transactions should be...

My apologies. The manager requesting this reporting changed his mind regarding the Aging process. If anything is taken out of the Account during the Reporting Period, he does not want that set of Transactions Aged. Only Amounts remaining in the Account at the end of the Reporting Period...

I have provided a marked-up Excel example for your review. I also provided some explanations above the columns to identify the data and how it is used. If more information is required for this, please do let me know. With that said, I will try to provide responses to the concerns you pointed...

THANK YOU VERY MUCH FOR YOUR PROMPT RESPONCE!!! In response to your additional questions: Q: First, suppose we have a complex of transactions over a period of a couple of months for account A but account B has only one transaction last week. You are trying to match balances against...

Thank you for your time and response. The data I have to draw from is from a Transactions table and not a General Ledger table. There is no "outstanding" invoices that I can reference. What I do have is an individual transaction that comes in with an "ROC" (Receipt of Cash) designation in...

I have collected data for a designated timeframe (Beginning Date and Ending Date) for Multiple Suspense Accounts. For discussion sake, let's say the reporting period is 1 week, though it could be different at times. Additionally, I have collected data for 6 months prior to the Beginning Date...

I apologize for any confusion. When I indicated the data was all in the A1 cell, what I meant was all of the data for the first record was in the A1 cell, just like a text or CSU file would display it when working with a comma delimited file. There are 59 individual records in this file so the...

I have an issue that I hope is child's play for someone with more experience coding than I have. I have an Assets.xlsx file that is actually a comma delimited file; all the data is contained within the A1 cell. I need to be able to append the input file's data into a table that I have defined...

I appreciate everyone's time and effort in providing a result for me. However, I found another source for an answer and will post it for reference: [CODE] Private Sub cmdUpdateTableNames_Click() DoCmd.SetWarnings (WarningsOff) DoCmd.OpenQuery...