Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by wcleve
-
-
Find maximum
I need help finding the maximum value of A for the day. If the maximum occurs several times, return the maximum A value equal to or closest > to 16:00. Example: Date A B C 1/1/05 14:00 300 10 5 1/1/05 15:00 300 8 3 1/1/05 16:00 100 5...- wcleve
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
Percent of time chart
Help...I am not sure how to word this, but here goes...well, here's an example of what i'm trying to determine... At 1pm, 5% of the time the temperature is within this x range, 10% of the time the temp is within x range, 20% and so on as necessary. Line chart - The series would be the 1pm...- wcleve
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
Finding min()
That did it! Golom, You're wonderful!!!!! [2thumbsup]- wcleve
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Finding min()
Golom, Thank you for your response. LINE_AMPS will not always be the maximum number of AMPS. LINE_AMPS will always be the number of AMPS associated with the figure in LINE for each SECTION. In other words, there is only one LINE value for each SECTION in which I need to return the AMPS for...- wcleve
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Finding min()
I'm having problems... Here's the table: Equipment ID AMPS LINE 10 956 10 750 10 1000 795 A 20 1000 20 1200 820 A 20 956 What I need to do is find the minimum amps for each id along with the amps for the line: ID AMPS LINE_AMPS 10...- wcleve
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
