Search results

  1. A

    Query Question

    Please forgive my ignorance as I am learning more by the day. I have created a query that has tracked duplicates by company name and shows the total spent per order. Is there any way I can get a grand total for all orders to show up in this query? I have looked at the help files but it really...
  2. A

    Subform problem

    First off, I want to thank all of you for your help as you have been great! I have a subform used for entering line items etc resident on my main form for requisistions. I have linked a child field in my subform lets call it "request number" to a text box on my main form called "call...
  3. A

    Combo Box Question

    I am trying to create a combo box on an order entry screen. How can I set the combo box so that when I pick a supplier name, all the pertinent info pops up in supporting fields. For some reason I only get info to go into one field and that is all the wizard asks me (which field) that the data...
  4. A

    Another Subform question

    I have created my purchase order subform. I am trying to create an expression that calculates my grand total and I have tried all of these =[name of subform].[form]![Grand Total] and I keep getting "name" in my box where I want the expression to be calculated. I have also tried using the...
  5. A

    subform

    Forgive my ignorance please. I am trying to create a purchase order program. I have a form that I can create purchase orders on. I would like to add a subform that lets me determine the number of line items I put in per order, rather than having a template that is part of the form . I have...
  6. A

    Subform Question

    Jack thank you but I still have this problem after studying the Northwinds example. Is there anyway I can create a subform without preset items that will perform the function that I need?
  7. A

    Subform Question

    I have fairly limited knowledge of access. I have a form that I have created to process purchase orders. I have tried to no end to insert a subform that would let me add multiple line items qty cost and total cost, that will let me add as many records as I want and give the grand total as part...
Back
Top Bottom