Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

values that are in table A but not in the table B

Status
Not open for further replies.

KMangan

Programmer
Aug 20, 2002
6
US
Hi,

I'm currently desginging a report with a datafile that will be linked to from VB. In the report I've selected 2 tables. I need to find all the values in table A that aren't present in table B. Is this possible from a datafile(no SQL allowed)

Any help would be appreciated.
Thanks,
Kathy
 
In your record selection formula:

IsNull({TableB.Field}) Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
dgilsdorf@trianglepartners.com
 
Thank you so very much, that did the trick!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top