Search results

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...

I have a table FIList which contains all the names and addresses needed for the cboBox fields. This should be the source. So for one record on the form there will be 5 fields that will use the FIList table. Each of these fields (name, address, city, ST, zip) on the form will hold a piece of the...

I'm not sure I understand how the filter would work? I would create a cboBox for each field (name, address, city, ST, zip). Hide the ID column and add the filter for each field?

Hello, I need some direction on how to set up a table and form to use several combo box controls in the form that will display the value not the id number in the table. I'll also need to use the values in a query later. The fields contain address information. I have a table of all the...

Hi James, Sorry if I wasn't very clear. I have a report that has 20 pages. Each page has a group 1 and a group 2. The group 2 fields are all summed. The group 1 is the subtotoal of all group 2. Ex. page 1 Department1 Cust1 Total of #s1 total of #s2 total of #s3 Cust 2 Total of...

Hi, I have a report with 2 groups. Subtotals for the 1st group on each page and a grand total on the last page. I need to have all of the 1st group's subtotals and the grand total on a separate page at the end of the report. I have no idea how this can be accomplished. Any help is much...