Need help on query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,

I have just started some work on access and currently i am stuck on 1 query.
I have a list of accounts alongwith project start date in below format:

Sr. No. Account Project Start Date
1 ABC 1-Apr-05
2 ABC 1-Apr-06
3 ABC 1-Apr-04
4 Xyz 5-May-04
5 Xyz 16-Jun-06


Now I want a report that should produce the results as below

Sr. No. Account Date when First project started
1 ABC 1-Apr-04
2 Xyz 5-May-04

Please let me know if this is possible.

Thanks for your help

D

--
Message posted via http://www.accessmonster.com

.

Relevant Pages

  • Re: send/receive stuck
    ... And on what account does it get stuck? ... Does Outlook hang completely? ...
    (microsoft.public.outlook)
  • Changing criteria in an access query based on a set of records in a table
    ... I need to run a query a number of times (exporting the results to excel via ... transferspreadsheet) each time the criteria of the Account Number field has ... to change based on a set of Account numbers in a table. ... using the table records as the criteria but here I am stuck on the syntax ...
    (microsoft.public.access.queries)
  • Re: What CANT you write about?
    ... ups or modes or story landscapes simply don't work for you on account ... get stuck on FTL travel or 95 pound waifs that kick reaver butt? ... I created a setting and characters for it. ...
    (rec.arts.sf.composition)
  • Re: windows XP working remoteley
    ... > i get stuck at adding a person, it says it cant find that user. ... do i have to use a user on the work computer? ... The computer you are remoting into must have an user account ... for example) that is already in the 'remote desktop users' group. ...
    (microsoft.public.windowsxp.work_remotely)
  • Re: messages stuck in local delivery for one account
    ... >> to that account gets stuck in the local delivery queue. ... >> troublesome mailbox and making a new account, ...
    (microsoft.public.exchange.misc)