Search results for query: *

Thanks!!

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

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...

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...

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!

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...

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...

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

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...

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...

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...

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...

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.

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...