Search results

  1. C

    Query to Multiply Values???

    Hello again, I need a final bit of help in my dB. Two fields in my table are "unitcost" and "totalvalue". In the previous MS Works 3.0 program that I am updating from, any time the user updated the unitcost value, the totalvalue number updated automatically, as if there was a formula embedded...
  2. C

    Additon to my last post

    Also, I have a field in my database that I need to enter a formula in, like Excel. One field is cost per unit, and the other is total cost... pretty simple, but I can't figure out for the life of me how to do it.
  3. C

    Importing Data from MS Works 3.0

    Hello, I am designing a db that keeps track of store room inventory. I am at the point of importing the data from the old program into Access 97. I have imported it several times, but I keeps getting blank fields in SOME records. Others come up just fine. I saved my Works 3.0 file as a text...
  4. C

    Query from Multiple Tables

    Ok thanks, I will try that method.
  5. C

    Query from Multiple Tables

    Yes but will I be able to query all 10 tables, or will I have to start over from scratch? Thanks
  6. C

    Query from Multiple Tables

    Hello Again. I need one last peice of advice. (I hope) My storeroom database has 10 tables in it that all have different classifications of parts. I need to have my users search for all of the parts supplied by one single vendor. Since vendors may supply several different types of parts, I...
  7. C

    Thank You to Everyone on this Forum

    Have to agree with Amy here. I recently started using this forum last week, and I am really getting my project going on the right start so far. I really appreciate the help you guys offer, and I hope to be able to return it soon. Mike
  8. C

    Starting with a Blank form

    I am designing a database where ONE or TWO users must be able to input data about a vendor, (Address, city/state, etc) I need to know how to make my form that they will use, open up blank, ready for them to enter in a new record. Every time I create a new form, it always opens on the FIRST...
  9. C

    Queries to Forms

    Hello, I posted a message a week ago about building User input queries for my storeroom database. I need to know how I can translate that query result to a form. Not just a table view. Thanks for the help on the first topic, and any help here would be greatly appreciated. Mike
  10. C

    Access Query Basic

    I know this may be a little bit of a simple request, but I really need some help. I am a network intern at a Chemical plant in Sauget IL. I am working on an Access database for our Storeroom. I am doing okay on forms, and navigation through my pages, but I can't figure out my queries. I need...
Back
Top Bottom