I have a table that looks like this
Location ServiceDay
Farmingdale Monday
Farmingdale Tuesday
Bethpage Monday
Bethpage Saturday
I'd like to have a query that gives me one row for each location like this
Location Sunday Monday Tuesday Wednesday Thursday Friday Saturday
Farmingdale Yes Yes
Bethpage Yes Yes
I want yes or space to show in column relating to the service day
Any ideas?
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.