There are many hypotheses in science which are wrong. That's perfectly all right: it's the aperture to finding out what's right. Science is a self-correcting process.
The value for PODID always returns as 0, so that the else statement never adds to an existing PO. I tried removing the nz operator just to see if it would run in this format and was told that I was using an invalid use of null.
Every time I order more product, it creates a new PO, rather than choosing between creating a new PO and adding to an existing one.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Microsoft Access 328.
