Search results

Hi Brianwarnock, I tried your suggestion; still skipping records?? Any ideas? Thanks, NLR

Hi Ranman256, I entered the following SQL: SELECT tblRecovery.CustID, Sum(Nz([tblRecovery.RecAmt],0)) AS SumOfRecAmt FROM tblRecovery GROUP BY tblRecovery.CustID; which fixes the error; however, the query only provides a record when there is a number returned. It skips the records with...

Hi, I'm not sure what's wrong... I'm trying to replace a null value with $0.00 for the second field in a query. My first try at the SELECT stmt did not contain any solution for a NULL value. The result was that it skipped the record. I need it to show 0.00 because the field is used in...

Hi Gasman, Sorry, I was pulled away for awhile... I have a Customer table, CustID, which is a one to many relationship to table, tblOverdrawnAccts. Table tblOverdrawnAccts has a one to many relationship to table, tblRecoveryAcctGLs. I created a calculated field in both tables, tblOverdrawnAccts...

I'm sorry this is so confusing... What is the source recordset for the form? tblOverdrawnAccts What is the source for those 3 fields. These are calculated fields in the query, qryTotalBalance. Which table is the 1 and which table is the many. tblOverdrawnAccounts is the 1 and...

SQL of my query: SELECT tblOverdrawnAccts.CustID, tblRecoveryAcctGLs.AcctID, tblOverdrawnAccts.TotalODAmt, tblRecoveryAcctGLs.TotalRecAmt, [tblOverdrawnAccts]![TotalODAmt]-[tblRecoveryAcctGLs]![TotalRecAmt] AS NetBalance, (DSum(" [TotalRecAmt]","qryTotalBalance"," [tblOverdrawnAccts]![CustID] =...

Hi Gasman, I only have access to Access 2010 and my db is quite large. I created a query to provide 3 fields to use on a form. The first totals the one side amounts, the second (which you've helped me with) totals the many side amounts, the third provides the difference of the two. I need to...

Ok, that worked. Didn't see that... Now I put these fields in a form using a Dlookup to display the results for the one side of each record; however it only displays the correct amount when the many side has only 1 record. As soon as it has more than one, the field is blank. Here is my code...

Hi Gasman, That worked!!! Yeah!! Ok, so now I need to add code that will force the formatting the results to currency. Would you be able to show me how to do this? Thanks sooooo much for your help!!! NLR:)

Hi Gasman, Thank you for your quick reply. I am trying the DSum... Here is the code I have so far: RecTotal: (DSum(" [TotalRecAmt]","qryTotalBalance",'[tblRecoveryAcctGLs]![RecAcctID]=[tblRelatedAccts]![AcctID]')) However access does not recognize the criteria. I'm not sure how to write it. I...

Hello, I'm currently using a Dlookup function to display a calculated field from a query. This works fine when only one record is entered on the many side; however when additional records are entered it doesn't add the additional records. What function/code can I use to add each record's total...

Hi, Is there code that will perform a search for an item contained in a field on a form and then find the next one (if more than one exists). I have an unbound field for the user to enter the number and then they would click a button to search of the unbound field contents. Not to sure if I've...

Hi, Thank you for your response. I changed the field, [tblRequests.RequestingDept] to text and added a FK number field to connect the combo box to the table. I also updated my query. (didn't know if I really had to do that) My SQL remains the same: SELECT tblRequests.RequestsID...

Hi, Any ideas...just checking in. Thanks, NLR

Yes, SELECT [tblBranchList].BranchID, [tblBranchList].Branch_Name FROM tblBranchList ORDER BY [Branch_Name]; This is used on the form, frmODReversalRequests. Thanks, NLR

SQL for qryRequestsByBranch follows: SELECT tblRequests.RequestsID, tblRequests.DateReceived, [FirstName] & " " & [LastName] AS Name, tblRequests.AccountNumber, tblRequests.NumberOfFees, tblRequests.TotalAmtFees, tblRequests.AccountType, tblRequests.CustomerType, tblRequests.CourtesyReversal...

Is there another way to provide the info? The site will not allow me to upload the DB due to security token missing.

I removed the code that closes the form; but still no luck. The query doesn't return any info. ???

I no longer need the form open after the query runs. The query opens but the record is blank. I should see at least one record. Thanks

Hi, It is a simple select query. One of the fields, [RequestingDept], contain the following Criteria: [Forms]![frmDepartmentList]![cboDepartments] which refers to my dialog box form combo box field. Thanks, NLR