lets see the dataset for this: SELECT [Award Date], [End Date], [PI- LastName], [PI- FirstName], [Grant Agency], [Grant Title], [$ Amount] FROM ['C] WHERE [Award Date] = '2007' Then the dataset for this: SELECT [Award Date], [End Date], [PI- LastName], [PI- FirstName], [Grant Agency], [Grant Title], [$ Amount] FROM ['C] WHERE ([PI- LastName] = 'baptiste' OR [PI- LastName] = 'macdermid')