Can we assume the "Process1" is dummy data and the processes will be different per job. If this is the case and you simply want the first process in a job followed by the second process in a job etc, then you must provide a value stored in a field that describes the order of the processes.
Duane Hookom
MS Access MVP
--- In MS_Access_Professionals@yahoogroups.com, "Troy Sherven" <tsherven@...> wrote:
>
> 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]
>
Tidak ada komentar:
Posting Komentar