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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: gusc999
  • Content: Threads
  • Order by date
  1. gusc999

    Sum (distinct count)

    Need some help with Summing (distinctCount) Formula 1: Sum (DistinctCount ({LABEL.LBSTOP}, {TRKEXTF.RHRTE})) Formula 2: Sum (DistinctCount ({LABEL.LBSTOP})) Error message "This Field Cannot be summarized" (PH) DPT Route Trn# Item# Pcs Stops (GH1) [Route] (D) DRY 101 12333 123213...
  2. gusc999

    Supressing "Detail Feilds" within a "Group Header"

    I have a report that is grouped into PO's I need to take the time from the first transaction and from the last transaction from that PO and get a time difference. Any Help would be greatly appreicated. -Gus HAPPY NEW YEAR!!!
  3. gusc999

    Time diff from one field

    I need to get the time difference from the "TranTime" field for each record in sequnce order; record 1 time differnce with record 2 then record 2 the time difference with record 3 so on and so on for all records through out the field. I have a productivty project were I need to identify the idle...
  4. gusc999

    Using Select Expert with a formula Field

    I created the formula field below to use it with the "Select Expert" but when I try to select it, it does not display the "@Ovr" field. Is there another way of doing this? I would greatly appreciate any help? [Field name "@Ovr"] if {PIRUSER.USWHDP}= "DRY" AND {PIRTRAN.PTTASK}= "LUNCH" AND...
  5. gusc999

    Max Function and Time Diff Issue

    Evening, I have been working on the query below for the past few days and I seem to be stuck. I have a couple issues hopefully one of you can help me with. RTE LHHSTD LDR STX SELC Cls X LDR ENX Selc Ldr Dif LDR CLT Strt End End Cls Strt Cls LDR# CREW SELC#...
  6. gusc999

    Time Diff and Max Function issue

    Evening, I have been working on the query below for the past few days and I seem to be stuck. I have a couple issues hopefully one of you can help me with. RTE LHHSTD LDR STX SELC Cls X LDR ENX Selc Ldr Dif LDR CLT Strt End End Cls Strt Cls LDR# CREW SELC# PTETIM PTTRN# 146 20080928 146...
  7. gusc999

    Time Diff Formula within the same Field

    Evening, I'm currently trying to create a time diff formula that will give me the time diff for RECORDS within the same field. I've had no luck and any help is greatly appreciated Thanks Time Diff between: 7:59 & 8:20 = 21min 8:52 & 10:29 = 37min Example below: DATE START END...
  8. gusc999

    Time Diff for Start and End time

    I am trying to get the time diff from two fields I converted the into time formats but when I try to diff(n,,) or {field1}-{field2} the time difference it does not give me the proper calculation can someone help me??? I'd greatly appreciate it. example: startime: endtime: difftime: 715pm...
  9. gusc999

    Any help would be greatly appreciated.

    Good Afternoon, I’m trying to figure out how to create query that will group the times by half hour increment and count them by those increments, in the [RHPRTT] field (military time). The query statement below was the one I used to generate this query below. Any help would be greatly...
  10. gusc999

    Any help would be greatly appreciated.

    Good Afternoon, I’m trying to figure out how to create query that will group the times by half hour increment and count them by those increments, in the [RHPRTT] field (military time). The query statement below was the one I used to generate this query below. Any help would be greatly...
  11. gusc999

    Help with the Count and Group function

    Good Afternoon, I’m trying to figure out how to create query that will group the times by half hour increment and count them by those increments, in the [RHPRTT] field (military time). The query statement below was the one I used to generate this query below. Any help would be greatly...
  12. gusc999

    Grouping a field and then Summing the total

    I'm having an issue with the following query I need to group the query by PIRF_SLOT1.SLITEM field and then sum the qty in the PIRF_SLOT1.SLSTK1 field for every item. SELECT PIRF_SLOT1.SLITEM, PIRF_PIRITEM.ITDESC, PIRF_SLOT1.SLPICK, PIRF_SLOT1.SLDISP, PIRF_SLOT1.SLSTK1, PIRF_SLOT1.SLSTAT...
  13. gusc999

    Excludng results from a query

    I've created a query the captures the item#, Buyer name, pack size, and item weight. The purpose to the query is to display items that exceed a certin weight, however I need to exclude certain items that have certin words in the description field ex. all shrimps from the description field. Is...
  14. gusc999

    Issue with a Expr2 field.

    I'm having an issue with the query below, I need the "Expr2" field to only display result with >= 8 after the subtractin but the onyl thing that comes up is a -1 for when the number is >8. I would greatly appreciate any advice. SELECT PIRF_ITEMMSC.IMBNBR, PIRF_ITEMMSC.IMBNAM...
  15. gusc999

    SQL Server Management Studio

    I am currently trying to connect to a DB2 database on AS400 system. The problem I'm having is that I dont have the the "odbc" driver for the AS400 server and I do not know what to use for the connection string when I get prompt for it. Please help... THank you!
  16. gusc999

    Mismatch error

    I have to two tables one has 2800 records the other one has 166 records. I have to join the tables by the item field. The 166 record table has duplicate item numbers which are need. When I create the join I get a mismatch error. I tried the left and right joins but it doesn't work. Can someone...

Part and Inventory Search

Back
Top