By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,406 Members | 2,660 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,406 IT Pros & Developers. It's quick & easy.

Select First Record in access table

P: 1
I have a table with over a thousand record. Each record contains specific information about the project, and that many are repeated from year to year with new entries until the finish. The question is how to extract from the table all year records with the first appearance in the report. With the "first" command in a query doesn't work. Thanks
Mar 11 '12 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,494
Basically, you find the minimum date represented in the table (I assume you have a date field in there. The question would be a stupid one if there is not even a date field to compare). When you have that date value you use the year part of that and filter the table on that. Any records whose year value matches the filter are from the first year.
Mar 11 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.