With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.
Create a new Query in Design View. Close the Add Table dialog box. From the Query menu, select SQL Specific, and then click Union. Add the following SQL statement to the Query: SELECT LastName & ", " & FirstName, EmployeeID FROM Employees UNION SELECT '(All)', null FROM Employees Save the Query as EmpUnionAll, and then close the Query. Open the Employees form in Design view. Double-click on the ReportsTo combo box to bring up the control properties. On the Data tab of the Properties box, change the Row Source to the EmpUnionAll query that you created above. Change the Bound Column property on the Data tab from 1 to 2. On the Format tab, change the column width from 0 to 2;0. Open the form in Form view. Notice that you can now select '(All)' from the combo box list.