sort out one months

R

Rowl

I have a database of projects. I need to see just projects completed in
specific month how can I make query etc.
 
D

Duane Hookom

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.
 
J

John Vinson

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]
 

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

HOW TO INPUT MONTHLY ACCUMULATED SALARY IN MS PROJECT? 0
Incone & Expenses Statement 0
Auto populate value from one task to another in MS PROJECT 0
Display weeks from a Milestone 0
Project spend over time 0
How to implement two shifts per day with multiple teams 0
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
Slideshow with black border around it 0

Top