Can one of you .net experts help out on this, please?
I have this query:
SELECT a.deptcode, c.deptname, em.check, em.cash,a.empl_first,a.empl_last, e.[e_mail],a.employee_id
FROM ctable c,[e_mail] e,Aempl a,EMamts em WHERE c.divisioncode = em.divisioncode
AND a.empid = e.empid
AND e.empid = em.empid
AND em.empid = '"&empid&"'
AND (isnull(em.check, 0)<> 0
OR isnull(em.cash, 0)<> 0)
which gives me the output below. This is the output we desire:
DeptCode DeptName Check Cash FirstName LastName EmpId
1540 IT 0 12 John Doe 19765507
1540 HR 0 13 John Doe 19765507
1540 Communications 1 0 John Doe 19765507
1540 Mental Health 11 0 John Doe 19765507
However, we would like to have layout similar to this one below:
Name: John Doe
Mental Health $11.00
I have played around with this all day but no luck.
Basically, we have an email component written in vb.net. This email will be used to send out the above data on that layout format.
I would appreciate any assistance.