I'm sure there is a simple answer to this, but I can't seem to find it. I think the problem is I don't quite know how to phrase the question properly for what I'm trying to do in order to search for the answer.
Basically, here is my issue:
I have orders in an SQL database which is divided into fields.
One field is the "Order information" field, which contains the basic order information like the customer name, the date the order was placed etc.
ALL the orders are listed here.
A second field is the "Order tracking information" field. Not all orders appear in this field. Only orders that have been shipped and had their tracking information logged are here.
Thus, if the order is not yet shipped, it is totally absent from the second field. It won't just be that the tracking info is blank, it will be totally absent from this field.
Both fields have an "Order_ID" item, which is what I use to match them.
I want to write a report that will show all orders and will also show the tracing information IF the order has it and if it does not will just print something like "No tracking info avaliable" or whatever.
Now here's the problem: When I try to include the "Order tracking information" in the report, it refuses to print the orders which are not in that field even if they have records in the "Order information" field.
How do I deal with this problem?
IP Logged
