Recent content by evr72

Just in case anybody sees this, I figured it out, not pretty but it works UPDATE AMFLIB2.CUSMAS T3 SET T3.ACREC = 'S' WHERE T3.ACREC IN ('A') AND EXISTS (...

Hello, I am trying to update a field, I have two join tables. I have tried a few things but keep on getting various errors two tables AMFLIB2.CUSMAS AND AMFLIB2.MBEKRES2 the field I want to update is in AMFLIB2.CUSMAS.ACREC the where statement uses the field EKCJNB from table AMFLIB2.MBEKRES2...

Is that the issue?

I used this to exclude Saturday and Sunday. I know I could have made it easier :) WHERE (CASE WHEN DAY ='SATURDAY' THEN 1 WHEN DAY = 'SUNDAY' THEN 1 ELSE 0 END <>1)

I use that to exclude Saturday and Sunday

Hello, Is there a way to get the last value in a column into the next row My table looks like this Day Begin Invoice Cash Change Ending 1 7500 2500 500 2000 [highlight #FCE94F]7000[/highlight] 2 [highlight #FCE94F]7000[/highlight]...

Hello, I have a windows 2003 server, it can resolve \\myserver\myfolder but when I try the ip address \\192.168.2.25\myfolder it cannot find the ip I can ping the server. never seen anything like this before Any help advice, I s much appreciated EV

Hello, I am a bit new at this one. I have a table for orders, each order has a unique number lets call it "UORD" I create a view with just the "UORD" field, is there a way to create a view and add fields to the view that can be edited? I tried the example below but it did not work, I got a...

Got the user working. When the user was given his laptop the wrong drivers were installed for IBM iSeries Client Access. Installed new drivers and fixed the issue.

Hello, I hope this is the correct place to post this. I have setup numerous odbc dsn connections, this morning, when helping out a colleague, using Windows 10 opened the ODBC admin window, clicked on add, select the ODBC Driver 32bit for iSeries, click on Finish and nothing happens, I usually...

Hello, I have a report that get the data from sql statements, it is looks something like this SELECT I9ADR7, CUSNM, SUM((case when yr = YEAR( CURRENT DATE)-4 then sales end)) AS "2013", SUM((case when yr = YEAR( CURRENT DATE)-3 then sales end)) AS "2014", SUM((case when yr = YEAR( CURRENT...

Hello, I have two tables, one that contains all the U.S. zip codes, city and state and a second table that contains 3 fields zip codemin, zip codemax, renumber I would like to get the rep number to the zip codes table. but not sure how to go about it. if I try to join the zip code it will only...

Hello, I am new at this sort of stuff, i am helping out a friend to improve his network, he owns a restaurant, he often has issues with the not being able to access the internet, he also offers free wifi ant any point upto 150 people can be connected to the internet, he does not have any...

vacunita, sorry for the slow reply, thank you!!! that worked!!!

vacunita, for some reason the code did not work I had some issues because the time being capturd is based on 24 hr I found the code below and it works well, the only issue I have is that it gives me a whole number Time in: 5:58 AM Time Out: 9:00 AM With the code below this is what I get...