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...
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...
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.
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.