experts please help on querying and counting the frequency of data, i want to count the number of data appearance then put it on like this:
Name----Lastname----Relationship----Freq
Egie----Tayag-------Brother---------2
i will place the result on a report counting the number of a person's visit on the theme park. TIA ^_^
SELECT relfirstname, rellastname, relrel, count(*) AS kamote FROM RelativeTable WHERE effectivedate = #" & frmNew.DTPicker2 & "# AND empnumber = '" & frmNew.empnotxt.Text & "' GROUP BY rellastname