There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand the world. There is no such thing as a dumb question.
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.
