I HAVE AN INVENTORY FILE THAT WAS COMPILED INTO A TEXT FILE AND THEN LOADED INTO MS ACCESS AND THEN TO CR. THE DATE FILE IS AN EXAMPLE 01/10/2000. WHEN I TRY TO SORT THE DATES IN CR, THE PROGRAM GROUPS THE MONTHS BUT INCLUDES ALL YEARS FOR THAT MONTH. I NEED A WAY TO LOOK AT CERTAIN YEAR WITHOUT ALL OF THIS OTHER USELESS DATA. DOES ANYONE HAVE ANY IDEAS???
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
CR DOES NOT APPEAR TO SORT BEYOND DAY & MO.
- Thread starter LMHODNETT
- Start date
If some data is useless to you for reporting purposes, it shouldn't be in the data that you are showing on the report.
Sorting data does not get rid of data, it just organizes it. What you need to do is to filter out the data you don't want. The simplest way to do this is with a Record Selection Formula. You will probably being doing something like picking only the records with a date in a certain range, or the year portion of the date equal to a certain value.
If you are not familiar with using the Record Selection Formula, the online Help has a pretty good introduction to it. Malcolm
wynden@telus.net
November is "be kind to dogs and programmers" month. Or is that "dogs or programmers"?
Sorting data does not get rid of data, it just organizes it. What you need to do is to filter out the data you don't want. The simplest way to do this is with a Record Selection Formula. You will probably being doing something like picking only the records with a date in a certain range, or the year portion of the date equal to a certain value.
If you are not familiar with using the Record Selection Formula, the online Help has a pretty good introduction to it. Malcolm
wynden@telus.net
November is "be kind to dogs and programmers" month. Or is that "dogs or programmers"?
I made a few assumptions...
SCR is looking at an Access database for this report?
The field that is causing a problem is a date or timedate field in Access?
The date field that SCR is sorting is interpreted by SCR as a date or timedate field? Malcolm
wynden@telus.net
November is "be kind to dogs and programmers" month. Or is that "dogs or programmers"?
SCR is looking at an Access database for this report?
The field that is causing a problem is a date or timedate field in Access?
The date field that SCR is sorting is interpreted by SCR as a date or timedate field? Malcolm
wynden@telus.net
November is "be kind to dogs and programmers" month. Or is that "dogs or programmers"?
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question