Search results

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

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

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

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

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

Hello, I don't want my user to type in the parameter value for a query in case of miss spelling. Therefore, I'm using a dialog box form with a combo box field. The row source of the combo field is a table with one field for the list. I've added VB code (Event Procedure) to a buttons on the...

Hello. I've created a button on my ACCESS 2010 form that will send a PDF via email. However I only need to send the single record displayed on the form not all records. The on click command of the button sends the PDF of the report. (I read that this is what should be sent; but still get the...

Hi, I need a little help with the following access query. I have a large table with many fields, three in particular that may contain the verbiage, /CTO/. I want to see all records except those that contain this verbiage. My query is using, Not Like "*/CTO/*" in a separate Criteria row for each...

Hello, Is there a way to add a field to a subform that preforms a net value calculation on all the records in that subform? Fields: Record ID ItemAmt PaidAmt Need a Net field here? (not part of form; description only) 1 500.00 100.00 400.00...

Hi, Can anyone help me? I would like my user to be able to enter dates on a report. I have entered unbound fields on the report; but it doesn't keep any of the information (dates) for printing or otherwise. (I don't need to save these dates since they change monthly.) Can anyone tell me how I...

Hi, I'm trying to obtain all of the information in a text field for a query. The user entered information and used a return (enter key) to enter information on a new line within the same field. The information after the return is not captured in the field in the query. Is there anyway I can...

Hi, I'm using the following for a field in a query: ITINERANT: IIf([Day and Time1] Is Not Null,[Day and Time1],IIf([Day and Time2] Is Not Null,[Day and Time2],IFF([Day and Time 3] Is Not Null,[Day and Time 3],IFF([Day and Time 4] Is Not Null,[Day and Time 4],IFF([Day and Time 5] Is Not...

Hello, I need some help with what I think is a running total for each day. I have a form that collects data several times in the day. I want a report to show a total for each day and subtotals for each column and grand totals. I can add the dates and used a running total to the report but the...

Hi, I need some help trying to update a field in a form using the after update event of a combo: Me.TextboxName = Me.ComboName.Column(4) I'm using the field name of the textbox in my form as the control source for the field. The Combo is a qry to use in multiple fields as an autofill display...

Hello, I'm working with Access 2010 and am trying to create a one to many relationship between two of my tables. Access will only give me a one to one relationship. The one side (tbl_DailyFiles) has a PK of DailyFileID and a FK of Pre-NoteID. The many side (tbl_PreNotes) has a PK of Pre-NoteID...

Hello, I am using a query as a subform and am getting the "Enter Parameter Value" window on several of my fields. The Parameter values its asking for are the Primary and Foreign keys. I've looked at my tables, and query and am not sure where I've gone wrong. Any suggestions where I should look...

Hi all, I'm fairly new working with Access and will need lots of help. :banghead:This site looks like it will be very helpful! Thanks to all in advance. NLR