I am having difficulty selecting only one item of data

[Billwork]

Below is a sample table (ProjectionRuns) I have in Access. I want to display some summary information from this table in Crystal reports (but only one element at a time).

ProjectionName Type Date ID

Name1 Projection 31/03/2004 1
Name2 Budget 09/04/2004 2
Name3 Projection 14/04/2004 3
Name4 Budget 10/03/2003 4
Name5 Projection 09/04/2002 5

Three data sets (and therefore three IDs) are used at any one time. I want to be able to state which three IDs I am refering to in the footer of the report.

Ideally, it would like something like:

Cash flow 1: Name1, Projection, ID: 1
Cash flow 2: Name2, Budget, ID: 2
Cash flow 3: Name5, Projection, ID: 5

However, as all of the ProjectionRuns information is stored as a ProjectionRuns.ProjectionName, or ProjectionRuns.Type etc. I will not be able to achieve it by using the following method:

Cash flow 1: <ProjectionRuns.ProjectionName> ...
Cash flow 2: <ProjectionRuns.ProjectionName> ...
Cash flow 3: <ProjectionRuns.ProjectionName> ...

As obviously the same information will be displayed each time. Can anyone help?

I basically want to know how to display specific data points from a table, where a common field name is used.

 

[synapsevampire]

I responded to your other post.

Please refrain from cross-posting the same question.

-k