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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Message box with days of month & date. 1
can I sort database by year if the field contains day/month/year 1
Crosstab query date field sorted by day instead of month 1
Calculating the days in a month 3
dates in table 2 fields need to be one field I can sort by date on 5
Extracting Month and day from Date field 2
Sorting Dates by Month and Day only 6
Network Days 3

Back
Top