Hi,
I am new to Jet reports and learning.
I want to get email address for employees from both the companies.
I have a column with employees number and just need to link to two separate companies. Employee numbers are unique and no employee would have same 'employee number' regardless of separate companies.
Any help will be appreciated.
Thanks,
Zee
Date
Votes
1 comment
-
Jet Reports Historic Posts Official comment Hi Zee,
There are a number of ways you could go about this. One way would be to have 2 columns for the 2 companies and do an NL function to the employee table to get the e-mail with a Company= filter from each company for that employee number. One of the 2 will come back as blank, so you can just use an Excel IF function in a 3rd column to get the one that's not blank and hide the first 2 columns (put the keyword "Hide" in Row 1 in those columns). The function to get the employee e-mail would look something like this:=NL("First","Employee","E-Mail","No.",C2,"Company=","Company X")
Does that work for you?
Regards,
Hughes
Please sign in to leave a comment.