[MS_AccessPros] Value from a previous record

 

I'm trying to write a query that will list each process in a job, and
also list the process name from the previous record, if it's within the
same job. Example: the first process in the job will not have a
previous process listed. When the job number changes to a new job, I
don't want to list a previous process for the first process of the new
job. All processes have a numeric process number, and the query is
sorted in numeric order ascending.

Here's an example of what I'm looking for:

Job# Process Previous process

1 Prepress -

1 Cutter Prepress

1 Fold Cutter

2 Cutter -

2 Coating Cutter

3 Cutter -

From my research, I've found some info on DLOOKUP, but I'm not sure how
to "reset" the previous process on the change of a job. Anyone have
ideas on how to do this?

Thanks,

Troy Sherven
MCD, Inc.

[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 3
• New Files 2

Visit Your Group

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

.

__,_._,___