Hello all,
I have a pc database, on a form I created an option group "Active, In Active, All", I now the output of the group is 1,2 or depending on what is selected.
I have a query for a report assets by employees.
I want the report to show only active or in active or all to the report. Is this possible
Here is the sql view:
SELECT DISTINCTROW Assets.*, [LastName] & ", " & [FirstName] AS [Employee Name]
FROM Employees RIGHT JOIN Assets ON Employees.EmployeeID=Assets.EmployeeID;
Thank you