Finding Omitted Records

[Agentshevy]

I have an attendance DB File that takes attendance of participants. By simply scanning their barcodes, their  timestamp are recorded. on a more detailed explanation, I have three tables: Participants, Attendance and Attendance_Line_Items.

 

The Attendance_Line_Items is presented in a portal placed on a layout from the Attendance Table. That is just the structure of the file. From the portal records, I have managed to calculate the TOTAL ATTENDANCE, TOTAL LATE participants and TOTAL EARLY participants. But I am currently faced with two major challenges:

 

1. How to get the Total of those that did not attend with respect to the Total Record of Participants I have?

2. How to get precisely, those Participants that did not Attend?

 

Please, I don't know if my topic really explains my intention for this post, but i am hoping whoever reads this would understand.. Thanks

[Lee Smith]

Show Omitted Only?

[bcooney]

I'm a bit confused by your structure. Typically, an event attendance has People<-Attendance->Event. So, can you tell me more about your data model, then I'll be able to provide a better answer.

 

For example, using the above structure, Total Attendance is a simple count of records in the related Attendance table. As for "late" or "early", I would imagine you would be comparing their "scan" time with a "start time" in the Event record.

 

Total who did not attend, could be total attended - #records in the People Table. Unless, each event has an "invited" list.

[Agentshevy]

thanks bcooney for your reply.. My structure is exactly like you stated..

People<-Attendance->Event

like i said, so far I have been able to get the following:

Total People that Attended

Total people that came Late

Total people that came Early

but my challenge is how to get the following:

Total people that did not Attend and not just the Number, but their details aswell such as ID

[Ocean West]

http://www.briandunning.com/cf/193

 

Get a list of ID's from the attendance table for an event 

Get a list of ID's of the people (total population)

 

Zap the two lists - returns the people who did not attend. 

 

-- or -- 

 

Find the one event record

GoToRelated Records from Event >--<attendance>---<People

Show Omitted

A set of people that did not attend this event.

[Agentshevy]

thanks Ocean West for your reply.. Looks like the second option is more understandable to me.. Please how can I script this? Because I will need to use this as a button

[bcooney]

A quick demo.

EventsDemo.fmp12.zip

[Agentshevy]

thanks bcooney..

[Agentshevy]

just finished my little lesson while studying the sample file. I can only say wow!! I have really learnt alot, was able to tackle more than the tasks I highlited earlier just with this file...

Thanks bcooney, for coming to my rescue.. And to you Ocean west.. Thanks a million

[bcooney]

Glad to hear it.