Query that changes each month

[BillyRogers]

My dept has a table with colums like this

TaskNo,Owner,Desc,DueDate etc.....then Jan,Feb,Mar,Apr,May,Jun,July.....

we each have our own query filtered on owner and each month we bring in the
correct month and mark our task as completed when were are done under the
month column with they day it was completed.

Is there a way to create a query that always pulls the current month? (or
the prior month which is really what I need)

Is there a better way to desing this? Do we need two tables?

thanks,
Billy
--
Billy Rogers

Dallas,TX

Currently Using SQL Server 2000, Office 2000 and Office 2003

 

[Jerry Whittle]

You certainly need some sort of design change. Any time that you have
something like Jan,Feb,Mar,Apr,May,Jun,July for column headings, there's a
problem.

If you just need the completion date for a particular Task and Owner, you
really only need one date/time column called something like CompleteDate.
Then there are a number of ways to extract what month/year the job was
complete.

If it's more complicated than that, you may need another table instead.

 

[BillyRogers]

"You certainly need some sort of design change." ...that's what I'm trying to
figure out....exactly what I need to change.

This task list is for a set of reports that have to be done each month by a
specific date. There is column that list the day of the month (10th, 20th,
25th etc).
People use the table to see what they have to do each month and what they
have already done for the month.


--
Billy Rogers

Dallas,TX

Currently Using SQL Server 2000, Office 2000 and Office 2003