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: JW61
  • Order by date
  1. JW61

    Unique Records with Duplicate Fields

    Thanks!!
  2. JW61

    Unique Records with Duplicate Fields

    Sorry missed that when I was creating the sample data. Yes I would need that one also.
  3. JW61

    Unique Records with Duplicate Fields

    I need a query to tell me when I have the same item but with a different range stored in the same location. Example, using the data below I would like the query to return Item 1, P1, A1, and 1, M1, A1 because it has two different ranges of the same item stored in the same location. Also need...
  4. JW61

    Convert rows of data to single row

    I have data in the format of : 123 AAA 789 EEE 1 123 AAA 987 FFF 1 234 BBB 102 HIJ 2 234 BBB 203 LKJ 1 234 BBB 304 TTT 3 456 CCC 717 ASD 1 456 CCC 191 ZXC 2 What I is to convert the data to : 123 AAA 789 EEE 1 987 FFF 1 234 BBB 102 HIJ 2 203 LKJ 1 304 TTT 3 456 CCC 717...
  5. JW61

    Limit SubReport from printing

    Sorry it took me so long to reply. I've had family issues and had not had a chance to test your solution. Works great. Thanks and a star!
  6. JW61

    Limit SubReport from printing

    I have a report that has three different sub-reports. The report prints information for suppliers. I would like to be able to determine which subreports print based on a value stored in a table for that supplier. Sub-report 1 will print for all suppliers but I would like to be able to limit 2...
  7. JW61

    Running Total Query Help

    qryBalls SQL: SELECT OH.ITEMCODE, OH.DESCRIPTION, OH.OHQTY, OH.SUBINVENTORY, OH.LOT_NUMBER, OH.STATUS, OH.xLOT, OH.INCREMENT, OH.BALLDIA, OH.CONFORM FROM OH INNER JOIN tblBallSubInv ON OH.SUBINVENTORY = tblBallSubInv.Ball_Sub_Inv WHERE (((OH.ITEMCODE) Like "???84*" Or (OH.ITEMCODE) Like...
  8. JW61

    Running Total Query Help

    Thanks ... I have done that and have read dozens of threads. For some reason I just can't figure it out.
  9. JW61

    Running Total Query Help

    I have the following query: SELECT A.ITEMCODE, A.DESCRIPTION, A.OHQTY, B.TotSum AS BAL FROM qryBalls AS A INNER JOIN [SELECT ITEMCODE, Sum(OHQTY) AS TotSum FROM qryBalls GROUP BY ITEMCODE]. AS B ON A.ITEMCODE = B.ITEMCODE; Which returns these results: ITEMCODE DESCRIPTION QHQTY BAL...
  10. JW61

    How do I check if a database is open

    I need a way to check when the database is opened to see if it is already open by another user. If the user is the 'first' in then I want to run some update instructions. I know I can check for the existence of the dbName.ldb file in the same directory but as soon as I open the database the...
  11. JW61

    ODBC Connection to 2 Oracle Servers

    I use some code (below) that I found on this site to establish and refresh an ODBC connection to Oracle server/tables. And it works great. The problem I have is that I need to connect to two different Oracle servers using different login ID's. Using the information below I login to the FINANCE...
  12. JW61

    Compare two Memo fields

    I receive information from another system via a delimited text file which is imported into a table. The field ‘Desc’ was always such that I could use a text field. The information has now grown to that I have changed to memo field. Currently the information can be up to 1100 characters. I...
  13. JW61

    Regular Hours and OverTime Hours

    Sorry... time is hundreds without decimals... 4000 = 40.00. 1160 = 11.60 hrs. Yes OT is only calculated for any time worked over 4000 (40 hrs) for the week. PHV... You are da'man. A cut and paste of your code from above works perfectly. Many thanks. And a STAR.
  14. JW61

    Regular Hours and OverTime Hours

    I currently have the following SQl statement: SELECT A.empnum, A.weeknumber, A.date, A.SumOfhours, (Select Sum(sumofHours) From Table1 B Where B.[empnum]=A.[empnum] and b.[weeknumber]=a.[weeknumber]) AS TotWk FROM Table1 AS A ORDER BY A.empnum, A.date; Returns: empnum weeknumber...

Part and Inventory Search

Back
Top