EXPRESSION USED IN ACCESS FOR EMPLOYEES START DATE 1999?

D

Duane Hookom

This isn't nearly enough information for anyone to even make a guess at what
you have and what you need. Could you try again? Does your question pertain
to queries or what?
 
R

Rick B

Where? In a Query?
What is your database structure?
What are your field names?

If you add a field to a query such as...

StartYear: Format([StartDate],"yyyy")

Then in the criteria put...

1999


taylor said:
What is the expression used in acess to denote employees who started in
1999
 
T

taylor

Thank you for your suggestion The field is in Query.

Rick B said:
Where? In a Query?
What is your database structure?
What are your field names?

If you add a field to a query such as...

StartYear: Format([StartDate],"yyyy")

Then in the criteria put...

1999


taylor said:
What is the expression used in acess to denote employees who started in
1999
 
Top