[MS_AccessPros] Query to put multiple records into one record

 

I'm not sure if this is possible, but I thought I would give it a shot.

I have a table that stores process data for a job. There is a single
record for each process within the job. Each job may have 1 process or
it may have 10 processes. I'd like to do this through a SQL statement.

Current table:

Job# Process Process HRS

1234 Process1 7

1234 Process2 2

1234 Process3 1

Here's what I want my query to return:

Job# Process1 Process1_HRS Process2
Process2_HRS Process3 Process3_HRS

1234 Process1 7
Process2 2
Process3 1

Is this possible?

Thanks,

Troy Sherven

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 6

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___