Search results

Hmmm, I'm admittedly still a bit of a novice when it comes to things like this, and I'm definitely interested of getting in the habit of using best practices. Would you mind providing an example of how I might do that?

CJ London, thank you so much! That is exactly what I was looking for!!!

Sorry, I had trouble wording my original post just right and I obviously didn't do a very good. Let me try again. I have a form named frm_payoff_process. The form's purpose is to enter information about incoming payments from clients. The user enters the amount received into a textbox named...

I don't think I am, but maybe I'm not fully understanding the info in that link?

Is it possible to store a form's name as a string and then refer to that form by that string name? For instance, I have a form named "frm_payoff_process" that contains a textbox named "txtRecevedTotal", and I can refer to it with the following code: Forms!frm_payoff_process!txtReceivedTotal...

Strange. Oh well, here's hoping a similar issue doesn't come up in the future. Thanks again for your help.

I was going to give you some data this morning, but due to some payments made on accounts overnight the query results are different now and there are no dupes. Hmm. I do have the details of the two transactions from the same account that WERE showing yesterday, though: ACCT_NBR: 112345678...

so plog, I've actually run into a weird issue with the third subquery you created. For some reason, it's returning two transactions for one of my accounts, despite the fact that one of them has a higher value in the LastTransactionDate field (43 vs. 44). Any idea what might be causing this?

I completely agree!

That was definitely my problem when I originally tried to tackle it on my own. Using subqueries was actually the first thing I thought of, but I thought that more-experienced folks must be able to accomplish what I was trying to do with one query and I was determined to figure it out. The...

This works beautifully. Thank you so much. The logic makes total sense and I can definitely see some things that I should have tried out while I was experimenting/troubleshooting. Now I'll know next time something similar comes up. Thanks again!

Hardy har har. Sorry for going MIA for several weeks; I got frustrated and this sort of fell by the wayside for a bit. I also apologize if I've come across as a bit of a dummy or a paranoid loon. Let me start over and be explicit about what I'm trying to do and what I have to work with. I...

The only transactions that I'm interested in returning are 211 or 710. And to address your other comment, the fear is that I could lose my job if I reveal something that even remotely hints at real data. It's not me being coy or overly-cautious...it's me complying with company regulations.

I was trying to avoid that because there's sensitive data in them, but I've made some changes to the code to keep the overall structure the same: SELECT Max(TBL_TRANS.PROD_DT) AS MaxOfPROD_DT, TBL_ACCOUNTS.LOAN_NBR, TBL_TRANS.ACCT_NBR, TBL_TRANS.TRAN_CD FROM TBL_ACCOUNTS LEFT JOIN...

I'm trying to build a query that I know should be a simple one, but I can't seem to make it work. I have two tables: one is just account numbers, and the other has information on transactions run in our system. I'm trying to create a query that will return all of the accounts from the first...

Thanks, Paul. That's helpful. And Plog, I probably should have been more clear...I'm actually not using DCount in a query (I'm using it in a report), but I posted in this forum because it was related to queries. I guess in retrospect I should have posted to Reports.

I'm having a bit of trouble with the syntax for DCount, and I was hoping that someone could set me straight. I have a query called qry_recons, and I'm trying to count all of the results of the query that have a value of "ML" in the field LOAN_TYPE and that have a value of "Y" in the field...

Thanks for the response, guys. Paul, I'm beginning to think you're my guardian angel. So the problem is that I need to hand over a regular Excel spreadsheet that contains all of the information for each account in a single row. Regardless of how I get there, that's what I have to turn in. In...

I've been asked to provide account details on a number of accounts in our system, so I'm building a query that pulls account details from one table and financial details from another. The query needs to include a field that sums all of the payments that a client made over a particular time...

Yep, they were in the Details section. When I opened the report, the fields were blank.