J
jhicsupt
[CityName] contains the names of the cities. [ParadeDates] contain the dates
of all the events for that city.
I need the query to return the MIN of the [ParadeDates] and also the MAX of
the [ParadeDates] for each city listed. The MIN and MAX would be in two
separate fields.
So if Houston is listed 5 times with date ranges from 1/1/2007,
2/1/2007, 3/1/2007, 4/1/2007 and 5/1/2007. The MIN would be 1/1/2007 and
the MAX would be 5/1/2007.
There will be multiple cities, so then if there is another city Los Angeles,
then the earliest and latest date should be shown for that also.
Thanks in advance.
of all the events for that city.
I need the query to return the MIN of the [ParadeDates] and also the MAX of
the [ParadeDates] for each city listed. The MIN and MAX would be in two
separate fields.
So if Houston is listed 5 times with date ranges from 1/1/2007,
2/1/2007, 3/1/2007, 4/1/2007 and 5/1/2007. The MIN would be 1/1/2007 and
the MAX would be 5/1/2007.
There will be multiple cities, so then if there is another city Los Angeles,
then the earliest and latest date should be shown for that also.
Thanks in advance.