sql - MS Access information before a date -

im trying find employees hired before 1991. when run query "data type mismatch in criteria expression" mean?

this query:

select emp_num, emp_lname, emp_fname, emp_initial, job_code, emp_pct, proj_num employee emp_hiredate < '01/01/1991';

ive tried 01-01-1991 , january 1, 1991 , tuesday, january 1, 1991.

the format of hire date in table day of week, month, day#, year, ie) tuesday, november 8, 1994.

6 correct character use when including literal date value pound character (#).

your query should be

select emp_num, emp_lname, emp_fname, emp_initial, job_code, emp_pct, proj_num employee emp_hiredate < #01/01/1991#

Bready