grouping "yyyy" in a report where there is also text info

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Used "hmembdate, 7" in "Grouping/Sorting" in a report and this worked to pull
my records up in ascending order by the "yyyy." When I upgraded to Office
2003 this process was no longer functional. What can I do now? The field
info includes 13 spaces mm/dd/yyyy PP (the PP is letters)
 
Ann said:
Used "hmembdate, 7" in "Grouping/Sorting" in a report and this worked to pull
my records up in ascending order by the "yyyy." When I upgraded to Office
2003 this process was no longer functional. What can I do now? The field
info includes 13 spaces mm/dd/yyyy PP (the PP is letters)
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Try extracting the date from the string like this (use this expression
in the Grouping/Sorting field):

Mid(column_name,14,10)

Substitute the name of the column, that holds the string, for
"column_name."

Then set the GroupOn criteria (in the bottom of the Sort/Group dialog
box) to Year.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRJrT54echKqOuFEgEQLGwQCg9QeaEaL3K7dFKT3TqHUVD779ixYAnjOV
dJjjc0lqkUYH/QDKxlSid1FS
=1uLO
-----END PGP SIGNATURE-----
 
Back
Top