Joined: 08 Jun 2007
Online Status: Offline
Posts: 27
Topic: Return data from a related row Posted: 12 Feb 2016 at 4:13am
I am sure this is simple. I have a table with Item number, Price and cross number. ABCD, 2.00, 1234 1234, 4.00, ABCD What I wan to do is for Item ABCD select the price for the cross number in this case the result should be 4 instead of 2. Thank you
As per my knowledge, to achieve your requirement we need to use sub report.
Create a sub report with displaying only "Price column" and link main reports "Price and Cross Number" fileds with "Item Number".
Pleace the Subreport in price column in main report and test the report.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
