sort out one months

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database of projects. I need to see just projects completed in
specific month how can I make query etc.
 
You need to be able to ask more complete questions. We don't know if your
table or tables have any date fields. Also, we have no idea how you
determine if a project is "completed".

Apparently you think we can either see your application or read your mind.
 
I have a database of projects. I need to see just projects completed in
specific month how can I make query etc.
Click to expand...

There are several ways; probably the simplest to implement would be to
create a Query based on the table, with a criterion on the completion
date of
= DateSerial([Enter Year:], [Enter month number:], 1) AND < DateSerial([Enter Year:], [Enter month number:] + 1, 1)
Click to expand...


John W. Vinson[MVP]
 
Back
Top