how do I sort a date field in Access according to day and month, .

  • Thread starter Thread starter Guest
  • Start date Start date
Paul

Add two new fields in your query definition.

One will be
Month([YourDateField])
and the other will be
Day([YourDateField])

Sort by these.

Good luck

Jeff Boyce
<Access MVP>
 
Sorry, am still being slow here.
I'm using Access 2003 and so I'm setting my query definition in criteria -
is that right? So I select the date field and select the month then I need an
operator (And) then the second definition which is the the day (same date
field). This is what I've tried but no success - syntax error message. Must
be doing something wrong!
Any help please?

Jeff Boyce said:
Paul

Add two new fields in your query definition.

One will be
Month([YourDateField])
and the other will be
Day([YourDateField])

Sort by these.

Good luck

Jeff Boyce
<Access MVP>
Click to expand...
 
Sorry, am still being slow here.
I'm using Access 2003 and so I'm setting my query definition in criteria -
is that right?
Click to expand...

No, it's not right.

Jeff is suggesting that you create TWO NEW FIELDS in the query by
typing the Month() and Day() expressions in vacant Field cells in the
query definition window.

John W. Vinson[MVP]
 
Back
Top