Brian has attended:
Access Introduction course
Access
Not sure how easy this will be to answer without seeing the database but I'll ask anyway.
I have database which covers events and who attended. We sometimes get cancellations and list people has having attended, cancelled prior to the vent, just didn't show up. I'd like to see how many actually attended each event. Given the table for bookings shows the status for each attendee, can I use some sort of criteria to just select the people who attended?
Thanks
RE: Access
Hi Brian, thanks for your query. As long as your data tables are normalised and linked correctly, this should be entirely possible by simply running a query to create a new table (or using the Count function) listing all actual attendees according to what is in the status column. Bit difficult to write the query here without the database itself, but have a go and let us know how you get on.
Hope this helps
Anthony
