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
Click to expand...
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
Click to expand...
1999
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Functions 5
Dates 4
help designing query to get results 5
Employee Training Help 2
Look up within date range 2
How to change a date from 19990812 to 08-12-1999? 3
Start a mail merge upon opening the document 1
Adding a second employee to an event 2

Top