N
Nick T
Hi,
What i thought would be somthing simple, is turning out to be very
frustrating! Any help would be great!
I have a query with 4 columns - Product, Size, Date & Total.
The query is working well, however i want to sort the query, so that the
records appear in date order. I only seem to have the option to sort
'assending' or 'decending', which doesnt work. The date is displayed as eg.
'05 Januarary 08' etc, however when i sort it either assending or decending,
it sorts by the numbers as apposed to the actual date:
eg:
05 Janurary 08
05 February 08
06 Janurary 08
06 February 08
........and so on, which is no good as i have many records for each day of
each month.
I simply want it to display in date order, eg. 05 Jan, 06 Jan 07 Jan etc,
then move onto February.
Any help would be greatly appreciated.
Many thanks
Nick
What i thought would be somthing simple, is turning out to be very
frustrating! Any help would be great!
I have a query with 4 columns - Product, Size, Date & Total.
The query is working well, however i want to sort the query, so that the
records appear in date order. I only seem to have the option to sort
'assending' or 'decending', which doesnt work. The date is displayed as eg.
'05 Januarary 08' etc, however when i sort it either assending or decending,
it sorts by the numbers as apposed to the actual date:
eg:
05 Janurary 08
05 February 08
06 Janurary 08
06 February 08
........and so on, which is no good as i have many records for each day of
each month.
I simply want it to display in date order, eg. 05 Jan, 06 Jan 07 Jan etc,
then move onto February.
Any help would be greatly appreciated.
Many thanks
Nick