Trimming a number for grouping in a report

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

Guest

I need to trim the +4 digits off of zip codes in a report in order to group on the first 5 digits. I know it's simple, am having no luck finding the solution. If you have the quick answer, please post. I've tried "First" and "Trim" as well as contantanate but I'm sure I'm writing the string wrong.
 
I am not sure what you are trying to achieve and what the
string you are trying to manipulate looks like.

Having said that would a right(trim([yourfield]),4) work.

This would return "1234" from "Alaska 1234". The trim
function is only there to get rid of any trailing spaces.

If this is no where near what you require please respond
with some more information.

HTH,

Terry
-----Original Message-----
I need to trim the +4 digits off of zip codes in a report
Click to expand...
in order to group on the first 5 digits. I know it's
simple, am having no luck finding the solution. If you
have the quick answer, please post. I've tried "First"
and "Trim" as well as contantanate but I'm sure I'm
writing the string wrong.
 
Hi,

In design view of your Report select the menu option View > Sorting and
Grouping.

Within the Sorting and Grouping place something like the following:

=Left([Zip code],5)

For Group Properties set the Group Header or Group Footer to Yes (your
choice).

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Thread-Topic: Trimming a number for grouping in a report
| thread-index: AcQ3no/uhjSbPQg1TFijhbWhSgNh7g==
| X-WN-Post: microsoft.public.access.reports
| From: =?Utf-8?B?am95YmVtaW5l?= <[email protected]>
| Subject: Trimming a number for grouping in a report
| Date: Tue, 11 May 2004 14:26:03 -0700
| Lines: 1
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.reports
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.reports:137990
| NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
| X-Tomcat-NG: microsoft.public.access.reports
|
| I need to trim the +4 digits off of zip codes in a report in order to
group on the first 5 digits. I know it's simple, am having no luck finding
the solution. If you have the quick answer, please post. I've tried
"First" and "Trim" as well as contantanate but I'm sure I'm writing the
string wrong.
|
 
Back
Top