Report Grouping & Sorting

A

ARS

I have a field "Year" whose values are derived from a date as
format(lastdate, "yyyy/mm") as [year].

I am trying to sort on the "yyyy/mmm" and group on "yyyy" so that the first
page of the report will look like:

1999/01 ....
1999/02 ....
 
R

Rolls

Write a query that parses your date field into two fields and you should
have no problem grouping and sorting.
 

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

Access Getting Month periods to show in ACCESS query as 0 when there is no data for the month 0
printing report with date 3
Form Control Calendar date will not change its format 1
Format Date and Strconv 3
[newbie] Expression for building a percentage 1
Excel How to change the "Short Date" format in Excel? 4
Importing Date fields from Excel 2
Format Date 1

Top