I've already retired once (from the Navy after 20 years) and it was a good feeling. Part of me would like to give up the IT rat race, constant training,...

Our "normal" method for our web pages is .ASP. There are many resources to learn how to use .asp including http://www.asp.net. If you want to see how others build...

I've only been working with SQL for a little over a year and I knew half of the answers. I'm also my company's network admin and help desk for about...

It's the company I work for...

I work at a non-profit that provides services for people with disabilities and one of the perks is seeing our clients every day and the...

Yeah, keeping track of software licensing is a pain in the $$$. We have 14 servers and 200+ desktops at our company and are mostly an MS shop. I use...

It should be no surprise that employees are the number one threat to security. We've seen CIA agents, FBI agents, military personnel with top secret clearances give secrets to Russia,...

Steve,

Your not the only semi-happy MS user. My company has used Windows since Win 3.1 and the OS has gotten better with each new version. About 3 years ago we ran all...

No Unions! I'm all for standardization and uniform certifications...but unions stopped being useful in the U.S. back in the 1960s. Not they appear to be all about political power. We...

Gentlemen,

First off I've already fixed the problem. All I had to do was divide the info in both columns by 2. Each column contained the same incorrect information because the...

The rows that are incorrect contained direct deposit info, the other rows are correct because they are check info.

Your solution

select ((col1 + col2)/2) as rightInfo

from table1

where info =...

Thanks I'll give this a try. Why does the table have two columns with the same info? Beats me...the columns have different headings but I'm not an accounting guru so...

The upsize wizard did not give any option to choose the primary key. The SQL tables (2) are using the same primary keys as the Access tables.

Mike,

No VB code, just fields bound to a query. And no I did not create this. This was left to me by a former IT worker in the company. When...

I think part of this debate is what is more important training or education. Training is more focused on specific job skills, such as MCDB, or MCSE, or CCNA. These...

One big issue with hiring American workers is the lack of technology training in this country. Too many students would rather try to get rich playing sports instead of getting...