473,657 Members | 2,436 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Using DMax "a hard one"

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...
Nov 13 '05 #1
2 1582

"Alex" <ge****@yas1.fr eeserve.co.uk> escreveu na mensagem
news:b7******** *************** ***@posting.goo gle.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...


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


Nov 13 '05 #2
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.fre eserve.co.uk (Alex) wrote in message news:<b7******* *************** ****@posting.go ogle.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...

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1472
by: Robert Brewer | last post by:
Paul Moore wrote: > ...I *can* defend an argument that the proposal must > take a stance on the keyword proposed. The existence of people (me, > as an example :-)) whose vote would be changed by the choice of a > keyword implies that not taking a stance leaves those people with no > basis for making their decision. As I see it, there are two camps to whom we need to be "fair" in this: 1) Those who would reject the syntax if it used an...
17
7362
by: Fresh Air Rider | last post by:
Hello Could anyone please explain how I can pass more than one arguement/parameter value to a function using <asp:linkbutton> or is this a major shortfall of the language ? Consider the following code fragments in which I want to list through all files on a directory with a link to download each file by passing a filename and whether or not to force the download dialog box to appear.
10
5615
by: serge | last post by:
Using "SELECT * " is a bad practice even when using a VIEW instead of a table? I have some stored procedures that are identical with the difference of one statement in the WHERE clause. If I create a single View and specify also in this View the WHERE clause that is common in these stored procedures, I will have the new stored procecures changed to be like:
43
2713
by: markryde | last post by:
Hello, I saw in some open source projects a use of "!!" in "C" code; for example: in some header file #define event_pending(v) \ (!!(v)->vcpu_info->evtchn_upcall_pending & \ !(v)->vcpu_info->evtchn_upcall_mask) whereas evtchn_upcall_pending is of type unsigned char (and also evtchn_upcall_mask is of type unsigned char).
4
8501
by: Gérard Talbot | last post by:
Hello fellow stylers, What would be the best CSS equivalent of MSIE's wrap="off" and wrap="hard"? hard Text is displayed with wordwrapping and submitted with soft returns and line feeds. off Wordwrapping is disabled. The lines appear exactly as the user types them.
7
2457
by: sami | last post by:
Hi I am trying to write a facebook application in python - I have been programming simple desktop applications till now and am not really familiar with web apps Pyfacebook is the wrapper for the REST based Facebook API - there is a simple example for its usage as shown below: def simple_web_app(request, api_key, secret_key):
13
2924
by: marathoner | last post by:
I would like to read the following entries of mixed data types from a ascii text file using C#. This can be easily performed in C using fscanf. Is there an equivalent function in C#? 1 2 1201 1 -0.417597000000000D+06 0.129600000000000D+06 0.0 0.753000000000000D+03 0.198800000000000D+04 Marathoner
3
30200
by: ElBeardo | last post by:
Hello, I´m new to Python.. so this is a newbee question. I´d like to put the value enterd in the entryfield in a variable. I´m trying to build a calculator with python and TKinter, coding it in just python works good. But making it with TK is a bit hard. This is my unfinished code, i have tryed get() in many ways,.but I cant make it work. I´m only need to get knowledge about using get() now,.. I now there is other thing undone in this...
16
2043
by: Joe Strout | last post by:
One thing I miss as I move from REALbasic to Python is the ability to have static storage within a method -- i.e. storage that is persistent between calls, but not visible outside the method. I frequently use this for such things as caching, or for keeping track of how many objects a factory function has created, and so on. Today it occurred to me to use a mutable object as the default value of a parameter. A simple example: def...
0
8310
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8732
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8503
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8605
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7330
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5632
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4306
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2726
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1615
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.