Search results for query: *

To Lupins4 and Kchaudhry, got it! Left outer Join is the Magic needed. Once I got my tables linked right and the left outer selected, all is good now. Thanks of the quick and accurate turn on my query. Byron

Thanks much kchaudhry. But what you have passed is beginning to make some sense. Found the join types in the Database->Visual linking expert. Gave left outer a go and all that returned form my Order report was one line of "No Loc Data". This gives me the feeling that left outer or some...

Lupins46, thanks for the quick reply. If time permits, could you elaborate on what a left outer join is, or point me in the right direction to learn more. I've seen "join" disscussed in other threads...and had the big blank "what's that?" form over my think head. Will try a key word search...

Hello Tec-Tip experts, I need some Formula Magic for a very simple report. Running CR 8.5 working a FoxPro Database. Report parts and fields follow: GH1 Order No. Details ItemDes.(string) ShipQty(Number) Location(string) Challenge: there are many cases were there is no Location data...

I have to agree with JennieM. My fellow employees are thinking I have suddenly aquired god like computer skills. We have doing double and triple duty parameter entry wise for far too long and now thanks to you Reebo we only enter once now. Thanks Byron

New to CR (patience please), Vitals: CR 8.5, accessing a FoxPro Data Base via ODBC. Report uses Multiple Parameters (Order No.’s) that uses an Ido formula (Thanks Ido) that returns the data grouped on the Order No.’s in the “order entered” as Load 1, Load 2, Load 3 etc. for a particular truck...