This is the recordsource of the form
(after formatting)
Code:
SELECT [MEM-MemberWorkInfo].LName
,[MEM-MemberWorkInfo].FName
,[MEM-MemberWorkInfo].STATUS
,[MEM-MemberWorkInfo].IAN
,[MEM-MemberWorkInfo].INS
,[MEM-MemberWorkInfo].UnionHst
,[MEM-MemberWorkInfo].COSHHst
,[MEM-MemberWorkInfo].PLNum
,[MEM-MemberWorkInfo].Grp
,[MEM-MemberWorkInfo].WkPROV
,[MEM-MemberWorkInfo].LEVEL
,[MEM-MemberWorkInfo].[Term/Cont]
,[MEM-MemberWorkInfo].LANGUAGE
,[MEM-MemberWorkInfo].Room
,[MEM-MemberWorkInfo].EmpDate
,[MEM-MemberWorkInfo].WkEmail
,[MEM-MemberWorkInfo].WkPhone
,[MEM-MemberWorkInfo].Gender
,[MEM-MemberWorkInfo].SOSEffDate
,[MEM-MemberWorkInfo].PreSOSStat
,[MEM-MemberWorkInfo].[EX/LWOP]
,[MEM-MemberWorkInfo].Notes
,[MEM-MemPersInfo].LName AS [LName_MEM-MemPersInfo]
,[MEM-MemPersInfo].Street
FROM [MEM-MemPersInfo]
INNER JOIN [MEM-MemberWorkInfo]
ON ([MEM-MemPersInfo].FName = [MEM-MemberWorkInfo].FName)
AND ([MEM-MemPersInfo].LName = [MEM-MemberWorkInfo].LName);
When I run it, it shows no result set.
There are no records in Mem-PersInfo.
There are 3 records in Mem-MemberWorkInfo
MemNum |
LName |
FName |
Status |
IAN |
2016-458 |
Ernst |
Laurette |
RA |
AS678 |
2018-115 |
Till |
Shelagh |
NE |
AS123 |
2018-154 |
Smith |
Joe |
ME |
AS345 |
I'm not sure why Date and Time do not show???