Selecting first date of many per client

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table where each record includes client ID and a visit date. Each
client ID is unique,but there can be multiple records per client ID with
different visit dates. Is there a way to build a query that selects only the
first visit date for each client ID? Seems like there ought to be a way to do
this but I can't seem to come up with it. Thanks.
 
Hi dvw,

Yes of course there is way!

What you need is an aggregate, or totals, query.

You must group by clientID and select to show the minimum of VisitDate.

Good luck

Nick
 
Thanks Nick - I'll give it a go!

Nick 'The database Guy' said:
Hi dvw,

Yes of course there is way!

What you need is an aggregate, or totals, query.

You must group by clientID and select to show the minimum of VisitDate.

Good luck

Nick
Click to expand...
 
Back
Top