Access Project Mgt Template Count Issue - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Access Project Mgt Template Count Issue

Jonathan Harris

13 months ago

Hi, I am using the Access Project Management Template (non-modified from download) and some of the task count totals don't match up to the amount of tasks listed for that date ie. 3 tasks over the specific date should have a count of 3. Some counts are zero even though there are 3 tasks for that specific date. Is this by design? Am I not understanding the count feature or are you able to redirect me to the support forum article (couldn't find one).

eg. control source over the 21 days first "=Nz(DCount("TaskID","TaskT","ProjectID=" & [ProjectID] & " AND StartDate<=#" & [TargetDate] & "# AND EndDate>=#" & [TargetDate] & "#"),0)" through to last "=Nz(DCount("TaskID","TaskT","ProjectID=" & [ProjectID] & " AND StartDate<=#" & [TargetDate]+20 & "# AND EndDate>=#" & [TargetDate]+20 & "#"),0)"

	Jonathan Harris OP @Reply 13 months ago

	Kevin Robertson @Reply 13 months ago
Probably a Regional date problem. Access expects US dates (mm/dd/yyyy). I am assuming your format is dd/mm/yyyy. Format ISO Date Format

	Jonathan Harris OP @Reply 13 months ago
Thanks for the quick response, changing to ISO Date Format resolved the issue. I'll just remove the count feature so that there's no requirement to use ISO time.

Jonathan Harris OP @Reply

13 months ago

ps. Changing the control source format [TargetDate]+1,"mm/dd/yyyy" seemed to correct the issue for me with Australian regional time set.
"=Nz(DCount("TaskID","TaskT","ProjectID=" & [ProjectID] & " AND StartDate<=#" & Format([TargetDate]+1,"mm/dd/yyyy") & "# AND EndDate>=#" & Format([TargetDate]+1,"mm/dd/yyyy") & "#"),0)". Noting for my instance that modifying "m/d" to "d/m" in the TaskPlannerF object "Me.Controls("D" & Format(X, "00")).Caption = Format(D, "d/m")" also gave me the localised format that I need. Thanks

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View