Search results for query: *

Ian Waterman: So everything is working absolutely fantastic with the command you created for me. Would it be possible to add ANOTHER LINK? This means we would be linking a total of 6 tables in one command.... The purpose of the second link is to determine the last known scan location...

Ian Waterman! THANK YOU!!!! This worked just perfectly! I am sorry I didn't do it the first time, I just saw the second post and had wrongly assumed that the second response (from lbass) corrected something to your original response. I apologize. Thanks and thanks and thanks again for your...

Linda Bass: This works phenomenal! THANK YOU!!!! I did run into a hiccup though... The join between PACKAGING and SHIPPING data should be a LEFT OUTER JOIN... I didn't realize that this would happen, so I didn't note it in the first post. Pretty much if a serial number does NOT show up in...

Ian Waterman! Thanks for your prompt reply - it is very much appreciated! The related field is `packaging_trac1`.`SerialNo` and `packaging_trac_archive1`.`BarCode` (the two packaging tables) and `shipping_trac1`.`SerialNo` and `shipping_trac_archive1`.`Barcode` (the two shipping tables). I...

Hello: Even though this is a long post, I think the problem I have is fairly straightforward... Any help you can provide will be greatly appreciated! I have four tables that I would like to combine in a Crystal Report (using a command - or perhaps something else would work better??). I am...

Colorado Springs Guy! Wow! I was making that way too hard! Thanks for your prompt response :-) It worked out very well.

First time post, excited to see the response! Sample Data Available: Part Number Warehouse Avg Cost a 000 $1.25 a 200 $1.35 a 300 $1.55 b 000 $5.60 b 300 $5.65 b...