Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filtering a multivalued table

Status
Not open for further replies.

rcbatlinux

Technical User
Mar 30, 2001
80
0
0
US
Hi,

I have a situation where I have a table that is a multivalued table. Meaning, it has one key but has 15 or more value records (basically like an array). Problem is those value records are not identified as a number within the array.

My delimma is I need to say select the 3rd record value because it represents the 3rd month of the year. I created a running total to add a record identifier that works great in Crystal.

BUT, I cannot use that running total field in my selection filter.

Any ideas if there is a way to filter data using a running total field? Or any other suggestions?
I can explain in more detail if needed. thanks.

rcbatlinux
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top