Access

Resolved · Medium Priority · Version 2000

Wed 3 Jun 2009, 11:22 Delegate 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:54 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips