If statement question (I think)

February 14, 200817 yr

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.

February 14, 200817 yr

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.

February 14, 200817 yr

Author

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

February 14, 200817 yr

Author

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

February 14, 200817 yr

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.