Help needed in developing different stages on report

[analyst1]

Comparing 2 rows in report

Hi,

I need some help with a report i'm working on in access. What I have is a table with data that lists deliquency in terms of staff attendance. For example, if person A has more than 3 absences in Quarter 1, then they are in stage 1. If Person A has more than 3 absences in Quarter 2, they are in Stage 2 and on and on. My table looks like this:

NAME QUARTER # OF ABSENCES
Person A Quarter 1 4
Person B Quarter 1 5
Person A Quarter 2 3

I want my report to look like the following:
NAME QUARTER STAGE
Person A Quarter 1 1
Person A Quarter 2 2
Person B Quarter 1 1

Can anyone help me out here?

Please and Thanks

 

[analyst1]

BUMP


anyone?

 

[analyst1]

well anyone?

How do I compare data on 2 different rows on an access report?

 

[analyst1]

I'm sure someone knows how to compare rows in access?

 

[themurph2000]

I'm sure someone knows how to compare rows in access?

I think we need a little more information about how the database works. For example, how many absences would trigger a Stage 2 in the second quarter, how does it apply to the third quarter, are there stages beyond stage 2, etc.

You might have to tie a second table to the first one that has the system of stages and absences that trigger it. But without more information, it's difficult to tell.

 

[analyst1]

If staff has greater than 3 absences per quarter a stage will be triggered. For example, Person A had greater than 3 absences in the 1st quarter, so in my report after the 1st quarter they would be the only person under stage 1. Now if Person A had greater than 3 absences in the 2nd quarter as well, then they would be in Stage 2, whereas Person B did not have greater than 3 absences in the 1st quarter so nothing would happen to them but seeing as they would have greater than 3 absences in the 2nd quarter, they will be in stage 1.

Does that help?

 

[analyst1]

Does that clear up any questions you may have?

Any advice?