Search results

Brilliant! Can't believe I didn't see that. Thanks so much for your help!:D

I have a report in Access 2010 that is supposed to show an alphabetical list of members who have paid their dues for the year. The RecordSource for the report is an SQL statement as follows: SELECT MEMBERS.LastFirst, DUES.DuesDate, DUES.YearID FROM MEMBERS INNER JOIN DUES ON...

I keep getting a dta type mismatch error on a simple (I thought) onopen event. I'm trying to produce the records for a combo box from which the user can select the year for later processing. The choices should be this year and next year. The table Years has only one field, YearID, and it is a...

Thank you so much. Your solution works and now I just have to figure out how you did it!:D

I have a db containing contacts with a birth date field (call it BDate). I want to count the number of contacts falling within given age ranges. For example, the number of contacts between ages 20 and 24, the number between ages 25 and 29, and so on. Building a query that calculates ages...