Search results

  1. P

    Search help

    I have a database that I have created for lesson plans. I would like to have a search form that allows the user to enter particular information like subject/theme of a lesson and the the lessons pertaining to that subject are displayed. I would like for them to be shown in either a form or a...
  2. P

    Training Users

    CamStudio http://www.ehelp.com/camstudio/product/screenrecording/
  3. P

    Not saving!!! Lost all my work today

    Anti-Virus definitions
  4. P

    Totals and Running totals

    Rich, It's too large to post. Pat, The subtotal is queried and then accessed by a calculated field. When I add items, the total changes appropriately. What I am looking to do is, while in form view, be able to see the order, the total of the order, and the remaining balance in the spending...
  5. P

    Totals and Running totals

    OK. I'm new to Access and have been trying to create a database. I have most of what I want so far, but I have hit a stumbling block. I have totals of each invoice. I need to keep a running sum of all invoices per campus. Then I need to be able to deduct that from their account balance. I am not...
  6. P

    Advice on how to do this project

    OK. I understand that and have made the adjustments. Now everything works fine. The only thing I need to work out is how to establish 8 separate balances within the same database. I guess I need to find examples of invoicing and how customers are set up. I need to reflect 8 separate accounts...
  7. P

    Advice on how to do this project

    So I would need a query containing the Quantity and Cost fields and an unbound field of Subtotal? Then I would pull in Total in the footer by pulling in the Subtotal? Or should I put the Subtotal category and then have a query for the Total? I'm just beginning this. I did figure out why I was...
  8. P

    Advice on how to do this project

    Thanks for your replies. I have already started attempting the Access database. So far I have created a subform for the purchase orders (invoices). I am having a problem with the Total for the PO. I have a column for Quantity and one for Cost. Then I have a column for Subtotal (Quantity * Cost)...
  9. P

    Advice on how to do this project

    We have 8 campuses (to be 9 in the next year). Each of those campuses makes purchases each week. They must submit a purchase form and the buyers go out and buy what they have listed. We want to go to a campus allottment, meaning each campus has a certain budget that they must stay within. The...
Back
Top Bottom