Opened/Closed Weekly count and YTD

[Charlie Shaffer]

I'm not sure if this is a function that can be done on a form or not. What I
am trying to accomplish is creating a way to calculate the number of job
tickets opened and closed. I'd like to count the ones opened/closed this
week and a yearly total of each.

I have a parent table and a sub-table linked by a unique job ticket number.
The job ticket numbers are formatted in this manner (text field) -
"yyyy-mmm-increment". I have developed 4 separate queries that pull info in
this manner

WeekClosedCalcQry

Sub-table info
TicketNumber (No Criteria)
Date Criteria is >=DateAdd("d",1-Weekday(Date(),1),Date()) And
<DateAdd("d",1-Weekday(Date(),1),Date())+7
TicketSummary Criteria is Like "*Ticket Closed*"

I've been able to use it with a Count to count the number of tickets closed
this week correctly.

I've been able to use similar queries like this or ones pulling information
from the parent table to get the correct number of tickets. However, if I
try to put all the queries on a single form, I get some hugely inflated
numbers even if I've only got one text field counting the number of records
from the WeekClosedCalcQRY.

Is what I'm attempting even possible? If so, please explain how. I would
rather not have to open separate forms for each one of these. It's also
possible I may need to do this in a report rather than a form and I can
except that. I'll need some help if this is the case. Thanks.

 

[Piet Linden]

Use DCOUNT in an unbound control.