Dear listeners, I have a query question. I have a table with place names and dates(see below). A number of occurrences of a place name can occur within the same month. I wish to summarise the table in terms of the counts for each place for each month. I know what the query should give me i.e. what my final table should look like (see below). Any suggestions on how to formulate the query. This is most likely a really simple query but I cant figure it.
Thanks in advance for your time Table Desired outcome Placename Month Placename Month Count A Jan A Jan 4 B Jan A Feb 1 B Feb B Jan 1 A Jan ------> B Feb 2 A Jan A Jan A Feb B Feb Frank Barrett. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
