HELP!

I have a simple, single-user database, tracking paperwork on students. One field is the date the paperwork was written and the other field is what type of paperwork it is. Both fields are repeating fields, with 25 repetitions.

How do I search for a date or a type of paperwork, while restricting in to "if they appear in the first five repetitions only".

Thanks!!!

Hi,

What you could do is to transfer these 5 repetitions in 2 new fields

cFirst5Dates =

GetRepetition(Date,1)&"

I'm pretty sure I understand what you are saying, but let me double-check myself ...

First I create a NEW field, which is a calculation field. Name it "First5DateFields" and in the calculation box I put in the "GetRepetion" stuff you listed. Then I do the same thing for the Paperwork field.

Do I put each "GetRepetition" on a separate line as it appears on my screen, or can they just be separated with a comma?

Please clarify what you mean by "using new keys at Right side of relationship"?

Does this sound like I'm understanding you correctly?

Thanks so much for your help!

Hi,

The "

Thanks for your help. I'll mess with it some and let you know ...