Mulitiple Records fro mthe same table ?

[Paul Dennis]

I am trying to workout the total time within a month that a type of server
has been unavailable, which is proving dificult.

Table: PROBLEMS
FIELDS:

PROBLEM_ID
TYPE
OPEN DATE_TIME
CLOSED DATE_TIME

I can select all the problems for TYPE="SERVER" and all the problems that
month, but how to calculate the total open time which ticket b might
start/stop within ticket a start/stop hence should be discarded from the
calc, or ticket c starts aftr ticket a but finishes after hence should be
countered as ticket a start and ticket c stop. The amount of tickets of the
TYPE="SERVER" could be 1 or many.

Help - I just can't get my head around the query?

 

[KARL DEWEY]

Create a totals query.
Create field Month([OPEN DATE_TIME])&Year([OPEN DATE_TIME])
Change the Group By to WHERE.
Put Month(Date())&Year(Date()) in criteria.

Create field Month([CLOSED DATE_TIME])&Year([CLOSED DATE_TIME])
Change the Group By to WHERE.
Put Month(Date())&Year(Date()) in criteria.

Select field TYPE. Change the Group By to WHERE. Put SERVER in criteria.

Create a column named Monthly Total. Change the Group By to SUM.
Monthly Total: [CLOSED DATE_TIME] - [OPEN DATE_TIME]

 

[KARL DEWEY]

I was a bit hasty in my reply. It does not account for all factors this data
can entail.

Create a totals query.
Create field Month([OPEN DATE_TIME])&Year([OPEN DATE_TIME])
Change the Group By to WHERE.
Put Month(Date())&Year(Date()) in criteria.

Create field Month([CLOSED DATE_TIME])&Year([CLOSED DATE_TIME])
Change the Group By to WHERE.
Put Month(Date())&Year(Date()) in criteria.

Select field TYPE. Change the Group By to WHERE. Put SERVER in criteria.

Create a column named Monthly Total. Change the Group By to SUM.
Monthly Total: [CLOSED DATE_TIME] - [OPEN DATE_TIME]

I am trying to workout the total time within a month that a type of server
has been unavailable, which is proving dificult.

Table: PROBLEMS
FIELDS:

PROBLEM_ID
TYPE
OPEN DATE_TIME
CLOSED DATE_TIME

I can select all the problems for TYPE="SERVER" and all the problems that
month, but how to calculate the total open time which ticket b might
start/stop within ticket a start/stop hence should be discarded from the
calc, or ticket c starts aftr ticket a but finishes after hence should be
countered as ticket a start and ticket c stop. The amount of tickets of the
TYPE="SERVER" could be 1 or many.

Help - I just can't get my head around the query?