Search results for query: *

A bit more information. My first post lacked a few details. - The host and guest are able to communicate with each other. Internet is working fine - I have 4 nic's on the server. One is disabled for now (until i need it for remote desktop) and the other three are teemed - The DNS server...

- I am running Win server 2012 with hyper-v. - The domain server is a virtual server. The host is able to connect to the domain. - I am unable to make any clients on the LAN connect to the domain. I cant ping the client on the local area network from the DNS server. Clients are running Windows...

Thanks...for pointing that out...lucky... I had negative amounts as well

This also worked for me and I can run this for a lot of columns at one go.... USE EXCLUSIVE MASTER1 INDEX ON REF_NO TO MASTER1 DO WHILE .NOT. EOF() IF STAT='C'.AND. AMT1 >= 1000 NEWAMT1=AMT1/1000 REPLA AMT1 WITH NEWAMT1 SKIP ELSE SKIP LOOP ENDIF ENDDO CLOSE DATABASE SET DEVICE TO SCREEN...

Thanks this works perfectly

Where am I going wrong.... SET STATUS ON SET SAFETY OFF CLOSE ALL USE EXCLUSIVE MASTER1 INDEX ON REF_NO TO MASTER1 DO WHILE .NOT. EOF() IF STAT='C'.AND. AMT1 >= 1000 NEWAMT1=AMT1/1000 REPLA AMT1 WITH NEWAMT1 ENDIF ENDDO

Thanks, I am new to dbase. What would be the command to divide all the fields in a column by 1000.

Our Country is about to re-base its currency (Zambia). I want to remove the last three zeroes in a numeric field. Is there a single command that can be used at the command prompt to remove the last three zeroes in a column from all the records. Please Help. Thanks.