We help IT Professionals succeed at work.
Get Started

packing Slip Query

880 Views
Last Modified: 2013-11-28
I am trying to build a query that I can use to support a packing slip report.  I have a table (t-PackingSlip) that contains a packing slip number (increment), and a packing slip detail table [t-PackingSlipDetail] that contains specific shipment records. The relationsip between the two is one to many.

When a user creates a packing slip, they are prompted to enter an order ID number into a form for t-PackingSlip.  This action creates the packing slip ID number.  Then, they enter specific data into a sub form for t-PackingSlipDetail.

I would like to create a query that shows the following columns of data:  Original order qty., previous shipped qty., ship qty., and outstanding qty..  I think I've done a good job struturing my tables/forms/sub-forms to accommodate this calculation, but I can not quite figure out how to get started w/ the expression for the "previously shipped qty.".

When a user runs the packing slip report, they will be prompted to enter the packing slip ID number.  How do I insert a conditional expression that says, "Add all of the ship qty. values from packing slips that are less than the user entered packing slip number?"
Comment
Watch Question
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 19 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE