If statement question (I think)

[agtjazz]

I have a database with 2 primary tables – People and Apps. A person can apply for Round 1 and Round 2 or just Round 1 or just Round 2. A persona can apply for Round 1 two times with different details, etc.

My dilemma comes around with this logic- if a person submitted for Rd 1 and then again for Rd 2, we need a report on file for Round 1. If a person only submits for Round 2, we don’t need a report as there is nothing to report from previous rounds. So how do I do a calculated field that says is Rd 2 the first round applying for?

Thanks in advance.

[mr_vodka]

Can you give a better example? Are there more than 2 rounds? If there are, does it need to be completed in succession?

For example, if there are 4 rounds, then do they need to complete 1 and 2 in order? what happens if they do 1 and 3? Does the report get filed for 1 only?

More details are needed.

[agtjazz]

There are never 4 rounds. Sometimes 3 depending on budgets. Probably not this year

No they don't need to do 1 and then 2 and then 3..... they can do 2 only or they can do 1 only

or they can jump to 3

It's applying for travel reimbursements and the rounds are open for a certain time- like November is round 1 and February is round 2 and if there is a round 3 it will be April.

Hope that helps... if not entirely clear, I can provide more details. Please let me know.

Thanks again

[agtjazz]

PS they can apply twice (or more) to any round as well

For instance, John wants to be reimbursed for a Chicago trip and a Canada trip both in Round 1

[mr_vodka]

I think that you may be approaching this wrong.

It seems as though you should be searching for a set of records that meet your criteria and be printing the report based off thsoe records. IOW, you should find those records that are considered Round 1 and print those in a report.

The other round 2 and 3, 4 etc can be entered at any time. When you designate (perhaps with a field in a preferences table ) that it is now round 2, then the reports should print round 2 reports only.

[agtjazz]

I don't think I am explaining myself correctly... I have made a simple sample of what I am trying to do.

Any help would be appreciated

Thanks in advance

RDTest.fp7.zip

[mr_vodka]

Perhaps something along the line of this?

RDTest_mod.zip