Combine Date in One Field

[waqas]

Dear Expert,

i have one query as below.

SELECT TblTimeSheetTest.IDNUM, Count(TblTimeSheetTest.TandA) AS CountOfTandA, IIf([tanda]="Absent",Format([sday],"dd"),0) AS Absnt
FROM TblTimeSheetTest
GROUP BY TblTimeSheetTest.IDNUM, TblTimeSheetTest.TandA, IIf([tanda]="Absent",Format([sday],"dd"),0)
HAVING (((TblTimeSheetTest.IDNUM)=401764) AND ((TblTimeSheetTest.TandA)="Absent"));

it is giving me result of date format in day in each row but i want to combine it into one field in same query with count of absent days
and in other in one field it should be like this 1,3,7 how it will be?

[waqas]

Dear Experts,

have a look at my request please.

[waqas]

hi experts,

kindly look at my request.

[waqas]

no one replied. what happen experts.
kindly look at my request.

i have values in rows like first row is 3 second row is 8 third row is 19 and fourt row is 28 how can i combine in one cell by query

[geekgirlau]

If I am understanding you correctly, I think that would be difficult to accomplish. Is there any reason why you need it displayed in this way?