Search results

  1. E

    Concatenating Subform Details

    Hello, I have a receipt report where I am trying to combine the details of a student's order onto 1 receipt. Currently if an order from a student contains 2 different items I will get 2 receipts containing the details for each item. All of the information contained on both receipts is correct...
  2. E

    Combining Detail Items

    Any Ideas? Well, I don't get the "function fConcatChild not found" error any longer. Unfortunately now I don't get any message, the report opens and then closes without displaying anything. Additionally, I don't know what I changed that caused this. I don't have a problem recreating the query...
  3. E

    Combining Detail Items

    Anyone???? I've tried using the fConcatChild function from the following link. http://www.mvps.org/access/modules/mdl0004.htm When I insert it into a query and run it I get the error, Undefined function fConcatChild in expression. I made sure that I entered the function as Public but the...
  4. E

    Combining Detail Items

    Hello, I have a receipt report where I am trying to combine the details of a student's order onto 1 receipt. Currently if an order from a student contains 2 different items I will get 2 receipts containing the details for each item. All of the information contained on both receipts is correct...
  5. E

    Adding Payments Due for family members in query.

    Hello, You're correct. After I posted this I did some more work on the query and I came up with the following. I created the first query as follows. SELECT Members.HomeAddress, Members.FirstName, Members.LastName, Members.ParentsNames, Members.HomePhone, Members.PaymentDue, Members.Active...
  6. E

    Adding Payments Due for family members in query.

    Success Hi Jon, I read your post a second time, after stepping away from my PC for a couple of hours, and I finally understood your recommendation. I created the first query as follows. SELECT Members.HomeAddress, Members.FirstName, Members.LastName, Members.ParentsNames, Members.HomePhone...
  7. E

    Adding Payments Due for family members in query.

    Additional Assistance Please. Thanks Jon, I tried your suggestion and made the following changes to the query. SELECT Members.HomeAddress, Members.FirstName, Members.LastName, Members.ParentsNames, Members.HomePhone, Members.PaymentDue, Members.Active, Sum(Members.MemberDues) AS...
  8. E

    Adding Payments Due for family members in query.

    Hello, I have a query that lists members who have outstanding payments. The results of this query are being used to populate a winword mail merge document. The problem with this query is that if there are multiple members from the same family who owe then I will get an entry for each of them...
  9. E

    Adding Payments Due for family members in query.

    Hello, I have a query that lists members who have outstanding payments. The results of this query are being used to populate a winword mail merge document. The problem with this query is that if there are multiple members from the same family who owe then I will get an entry for each of them...
  10. E

    Passing a parameter to a combo box.

    Additional Assistance Hello MStef, Your attached database helped immensely. I now have a combo box named ViewActive that lets me selective Active=Yes, No or when I double-click it all records are displayed. When I select Yes then I only see active students when I use the record navigation to...
  11. E

    Passing a parameter to a combo box.

    Hello, I currently have a student membership database with a main Members form. When it opens it prompts me for a parameter which determines if only active, inactive or all members will be displayed. Once the form opens I use a combo box to search through all of the records. Currently this...
View older results
Back
Top Bottom