Search results

Hi I am looking for assistance in a query where I can group by COL1 and in COL2 it will find all data relating to the COL1 cell and group with a comma separating each cell. Example COL1 COL2 1 AA 2 BB 3 CC 4 DD 5 EE 1 FF 2 GG 3...

I am newish to MS Access. I require the equivalent formula from excel to mc access which will workout -1 day from my data-set less weekends/public holidays. So this is what i use in excel atm: =WORKDAY(start date,days,[holidays]) Any help would be greatly appreciated.