Due Project

[Tom]

Access 2003
I need to run a query that shows number of projects that due. Here’s a sample:

Proj1 DueDate Compl Proj2 DueDate Coml TotalProjDue
Stud1 2 Jan10 Jan8 3 Feb3 - 3
Stud2 1 Jan18 - 4 Feb10 Feb9 1

Each student is given number of projects in a month. If he hasn’t done his
project prior to it’s due date it’ll be accumulated to Total Due Projects
column (the last). I can do it in Excel, but I don’t know how to do it in
Access. I’m trying to use the query instead. Is it doable or what expression
I can use in Criteria window of the query.

 

[[MVP] S.Clark]

The output that you have displayed is a complex crosstab, but this is not
how you typically store data in a normalized database such as Access.

Please read about the first three "Normal Forms" of the Boyce-Codd theories
to better understand how Access expects data to be stored.