I have access database as below,
A Table called 'mydatabase' has following columns
there are other columns, but not relevant to this question.
i need to query following in excel s/s.
Query: for each Trunch No., Group by URN Nos. that start with 'i' , count of unique ID No.
Note: URN Nos will be like, EN232, ATS-232, I777, i am interested only in those that start with I.
PS: i have programming knowledge, but new to sql.
I was able to establish connections etc. but stuck up with this query.