Recent content by NLR

The outside source for the subCompany table uses the first 10 characters of the company name which is the only way I can know how it relates to the Main company table.

The data for the Customer Returns comes from an outside source and cannot be changed. I don't have a way to link the return table to the main table.

I have two tables one for returns and one that shows the main company. When I receive the info for the return it doesn't include the main company; just a sub company. I need to show the main company the sub refers to in order know what account it belongs to. I can create a query that will link...

I need to link the subform to the main form so that the subform will only show when linked to a record on the main form. I need to update a field on the main form. Is there a way to do this? I'm beginning to think I won't be able to... Thank you!

Ok, thank you for the info; however, I need to add one field from one query to another query and then display on a form (which I would like to be able to update). How can I do this? Thank you!

Hi Minty I will heed your advice going forward... thank you. I removed the field, but no luck. The only time I can update the record is when I remove the 3rdPartyList table. Any other thoughts? Thank you!

Good morning, I have the following query: SELECT [Customer Returns].[Return Fixed?], Mid([Company Name],18) AS [Comp Name], IIf([File Name]=[3rdPartyList]![3rdPartyName10],[3rdPartyList]![Customer]," ") AS Originator, [Customer Returns].[Processed Date], [Customer Returns].[Individual Name]...

I've made the updates and put the # bank in and now it's working correctly. I also added a currency format. Result: FormatCurrency(DSum("[DR $ Amt]","[Daily Originations]","[File Name]='" & [COName10] & "' And [SettlmtDt] Between #" & [SettlmtDt]-2 & "# AND #" & [SettlmtDt] & "#"))...

Hi, I removed the # marks from the dates and no longer received an error message; however I'm not sure what I should see for the results. I've attached a slimmed down version of the database for your review. Thank you!

Good morning, I've updated the expression. I'm now getting the error message; "The expression you entered has an invalid date value." #" & [SettlmtDt]-2 & "# The data type for this field is Date/Time. I've also tried MarkK's suggestion with not luck and the same error message...

Thank you for that info. Good to know. I'm still fairly new at this. I changed the field name and took our the speech mark. I now get an error message stating: "The expression you entered has an invalid date value." Here is the full expression (with some name changes). Result...

Not sure why that would make a difference if it's enclosed in brackets?

Hi, I've entered the information. I'm getting the error message, "The expression you entered has an invalid date value." On #" & [Settlm't Date]-2 & "# Would you know what went wrong? Thanks!:)

First, would you please explain how this section of the query works: ","customerID='" & [customerID] I don't understand what this does in a query. Thank you.

Hello, Is there a way to calculate a running total on an amount field based on a running three day span (SettlmtDt field) in a query? Then, I want to compare the new total amount to a static limit amount. If it’s over, I want to see the record. The query has two tables; customer and...