specific query

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

Guest

I have a log table capturing document assignments.
It has a column for:
1. Date_Assigned
2. Revised commit date
3. Status (In Work, On Hold...ect)
4. Actual Completion Date
I need to create a query so that I can create a chart to plot month by month
how many jobs (the count only) were still during that month. I am pulling my
hair out. Not much left ... so hurry with help!!!!
 
Slow down and express your problem clearly and precisely!

* What is the relationship between "document assignments" & jobs?

You explained about the first one and you asked question about jobs and
there is no relationship between the two.

* Which count of jobs do you need? Started jobs? Outstanding job? Completed
jobs?

"were still" doesn't make any sense in the context.

Remember, we can't see your database and don't know precisely what you need
and rely on the description in your post. Perhaps, you should always
re-read what you are about to post and see if others who don't know a thing
about your database or your requirements can understand the post.
 
Back
Top