Code: Select all
SELECT Sheet1.Symbol, Sheet1.Company, Sheet1.Dividend, Sheet1.[Pay date], Sheet1.[Ex Date], Sheet1.Announced, Sheet1.Recorded
FROM Sheet1
WHERE (((Sheet1.Symbol)=[Enter Symbol]))
ORDER BY Sheet1.[Pay date];
Code: Select all
SELECT Sheet1.Symbol, Sheet1.Company, Sheet1.Dividend, Sheet1.[Pay date], Sheet1.[Ex Date], Sheet1.Announced, Sheet1.Recorded
FROM Sheet1
WHERE (((Sheet1.Symbol)=[Enter Symbol]))
ORDER BY Sheet1.[Pay date];