Restrict query to first meeting date (1 Viewer)

[Peter Peterson]

Hi - it's been a while since touching Access, and rarely ever used queries
I am using the latest version of Office 365 on latest version of Windows.
I have a table of Clients and a Table of Meeting Dates
I need to restrict the list to the first meeting date.
I am getting a list of clients duplicated for every meeting date.
Any advice will be most welcome.
Thanks Peter

 

[theDBguy]

Are you trying to return one record for each client by finding out their first meeting date?

 

[Peter Peterson]

@theDBguy
Yes - returning one client record showing the first meeting date
What I'm getting is a client record for every meeting held -

 

[theDBguy]

@theDBguy
Yes - returning one client record showing the first meeting date
What I'm getting is a client record for every meeting held -

You could try using a Totals query. For example,

SELECT Customer, Min(MeetingDate) As FirstMeeting
FROM TableName
GROUP BY Customer

 

[Peter Peterson]

Thank you - works as I hoped
Cheers Peter

 

[theDBguy]

Thank you - works as I hoped
Cheers Peter

Congratulations! Glad to hear you got it to work. Good luck with your project.