Selecting first date of many per client

[dvw]

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.

 

[Nick 'The database Guy']

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

 

[dvw]

Thanks Nick - I'll give it a go!

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

 

[Nick 'The database Guy']

Any success?

Nick

Thanks Nick - I'll give it a go!