Only include first record

richardm90 — Thu, 13 Sep 2018 08:40:35 GMT

Hi,

I'm doing a count statement where I only want to include the matching record in the count if it is the first record by date

i.e. In the records below if I was counting the amount of ID's that had a letter of B. I would only include the one from the 2nd ID (456) as B is the first chronologically.

ID	DATE	LETTER
123	01/08/2018	A
123	02/08/2018	B
123	03/08/2018	C

ID	DATE	LETTER
456	01/08/2018	B
456	02/08/2018	A
456	03/08/2018	C

Any help would be much appreciated.

Re: Only include first record

bramkn — Thu, 13 Sep 2018 08:53:50 GMT

the function firstsortedvalue()

topic Only include first record in App Development

Only include first record

Re: Only include first record