Convert database table

Account Information

Reset password

An email has been sent to you with instructions on how to reset your password.

Back to TechRepublic

Welcome to TechRepublic!

By registering, you agree to the Terms of Use and acknowledge the data practices outlined in the Privacy Policy.

You will also receive a complimentary subscription to TechRepublic's News and Special Offers newsletter and the Top Story of the Day newsletter. You may unsubscribe from these newsletters at any time.

Username must be unique. Password must be a minimum of 6 characters and have any 3 of the 4 items: a number (0 through 9), a special character (such as !, $, #, %), an uppercase character (A through Z) or a lowercase (a through z) character (no spaces).

General discussion

Creator

Topic
September 15, 2004 at 11:33 pm #2277822

Convert database table

Locked

by peter_tan · about 17 years, 8 months ago

Can anyone advise how could get the following result in MSAccess.

Original:
Name A B
Peter 10 20
Mary 50 40

To this below :
Peter A 10
Peter B 20
Mary A 50
Mary B 40

Would appreciate some help, thnak you

Rgds.

This conversation is currently closed to new comments.
Creator

Topic

All Comments

Recruiting an Operations Research Analyst with the right combination of technical expertise and experience will require a comprehensive screening process. This Hiring Kit provides an adjustable framework your business can use to find, recruit and ultimately hire the right person for the job.This hiring kit from TechRepublic Premium includes a job description, sample interview questions ...

The digital transformation required by implementing the industrial Internet of Things (IIoT) is a radical change from business as usual. This quick glossary of 30 terms and concepts relating to IIoT will help you get a handle on what IIoT is and what it can do for your business.. From the glossary’s introduction: While the ...

Procuring software packages for an organization is a complicated process that involves more than just technological knowledge. There are financial and support aspects to consider, proof of concepts to evaluate and vendor negotiations to handle. Navigating through the details of an RFP alone can be challenging, so use TechRepublic Premium’s Software Procurement Policy to establish ...

IT Employment

General discussion

Convert database table

All Comments

How to recruit and hire an Operations Research Analyst

Quick glossary: Industrial Internet of Things

Software Procurement Policy

How to recruit and hire a Security Analyst