98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Access
Access
Resolved · Medium Priority · Version 2000
Wed 3 Jun 2009, 11:22Delegate Brian said...
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
Mon 8 Jun 2009, 11:54Trainer Anthony said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Create calculated fields that work out your ageYou can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field |
