Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Gregshah

    Using a Total Sum Value in an Expression in the Same Query

    Thanks Randy. I just needed to play with the formating of the formula. It works fine now.
  2. Gregshah

    Using a Total Sum Value in an Expression in the Same Query

    I did not explain myself correctly. I have a value called [actual weight] that is specific to a job. I have a second table that records each shipment weight for the job. There may be several shipments for a single job. I want to total the shipment weights and subtract the shipped weight from...
  3. Gregshah

    Using a Total Sum Value in an Expression in the Same Query

    I am using a query to add together numerous values for a total. I would like to take this total number and subtract it from another constant value in a related table. I want to calulate a balance of weight to ship by taking the full shipment weight minus the sum of the individual shipments. I...
  4. Gregshah

    Creating Outlook appointment on calendarf rom Access data

    I have seen similar programs that will take travel data such a flight times or hotel confirmation numbers and will copy them to my calendar. This is the type of program that I am looking for.
  5. Gregshah

    Creating Outlook appointment on calendarf rom Access data

    I would like a method to take infromation concerning a quotation number, customer and due date from an Access database and put the due date on a calendar in Outlook. I am not familiar with any type of code writing but if there is a program or something that would do this, it would certainly...
  6. Gregshah

    Access-Creating library for pull down list

    There are an unlimited number of potential parts that could be required for a project. I plan on starting off with a fairly large database of the most used components. I know that as we continue to use this system, different parts will be needed. I know I could add the new part directly into...
  7. Gregshah

    Access-Creating library for pull down list

    I want to create a table with various part numbers and other data that I can use as a pull down list to create a bill of materials of all the parts needed on a specific project. However, if a part is not in my master library of parts, I would like to be able to type in the information into my...
  8. Gregshah

    Parametric query with Multiple Answers

    I would like to develop a query to pull information about a single job number or in some cases, a group of job numbers. Can I use a parametric query that will let me enter a single job number or multiple? I tried putting commas, semicolons, spaces etc to separate the job numbers but it did not...

Part and Inventory Search

Back
Top