Using DMax "a hard one"

[Alex]

I am in need of help for a problem using Dmax to find out the cycle
time of a machine which was running for an 8 hour shift "BUT" the
cycle time is changing for what was on the machine for that period.

I have set up using a union query the to show the following:-

what i would like it to do is work out the "max" cycle time for a
given period for which it ran up to when it changes = of
(Start/finish)
JOB Ref Time ON-OFF Cycle time

100 07:00 ON 1.5
200 07:00 0N 1.3
300 07:00 0N 1.5
100 10:00 OF.... 1.5 .......Max 1.5
400 10:15 ON 2.5
200 15:00 OF .... 1.3........Max 2.5
300 15:00 OF .... 1.5........Max 2.5
400 15:00 OF .... 2.5 .......Max 2.5
Is this possible or am i going at it totally wrong! any other options

appreciate any help

Thanks...

[Roberto Spier]

"Alex" <ge****@yas1.freeserve.co.uk> escreveu na mensagem
news:b7**************************@posting.google.c om...

I am in need of help for a problem using Dmax to find out the cycle
time of a machine which was running for an 8 hour shift "BUT" the
cycle time is changing for what was on the machine for that period.

I have set up using a union query the to show the following:-

what i would like it to do is work out the "max" cycle time for a
given period for which it ran up to when it changes = of
(Start/finish)
JOB Ref Time ON-OFF Cycle time

100 07:00 ON 1.5
200 07:00 0N 1.3
300 07:00 0N 1.5
100 10:00 OF.... 1.5 .......Max 1.5
400 10:15 ON 2.5
200 15:00 OF .... 1.3........Max 2.5
300 15:00 OF .... 1.5........Max 2.5
400 15:00 OF .... 2.5 .......Max 2.5
Is this possible or am i going at it totally wrong! any other options

appreciate any help

Thanks...

Hi,
as you have an union query, say [union_query],

instead Dmax, an alternative way would be with a query that retrieves the
max Cycle Time with a subquery, something like

Select *,

(SELECT Max([Cycle Time]) FROM [union_query] As UQ
WHERE [union_query].ON-OFF = 'OF'
AND UQ.[Ref Time] <= [union_query].[Ref Time]) As [Cycle Time]

FROM [union_query]

Hope my english makes sense :)

Roberto

[Robert Hogan]

Not sure I understand what you are asking for...

Can you post your desired result set? Are you looking for a single
value or multiple values? How are you using the results?

ge****@yas1.freeserve.co.uk (Alex) wrote in message news:<b7**************************@posting.google. com>...

I am in need of help for a problem using Dmax to find out the cycle
time of a machine which was running for an 8 hour shift "BUT" the
cycle time is changing for what was on the machine for that period.

I have set up using a union query the to show the following:-

what i would like it to do is work out the "max" cycle time for a
given period for which it ran up to when it changes = of
(Start/finish)
JOB Ref Time ON-OFF Cycle time

100 07:00 ON 1.5
200 07:00 0N 1.3
300 07:00 0N 1.5
100 10:00 OF.... 1.5 .......Max 1.5
400 10:15 ON 2.5
200 15:00 OF .... 1.3........Max 2.5
300 15:00 OF .... 1.5........Max 2.5
400 15:00 OF .... 2.5 .......Max 2.5
Is this possible or am i going at it totally wrong! any other options

appreciate any help

Thanks...