Re: Sorting Problem on report

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 06/16/04 

Date: Tue, 15 Jun 2004 21:00:56 -0500

Oops, have you tried this with a text field? 

-- 
Duane Hookom
MS Access MVP
"Sue" <anonymous@discussions.microsoft.com> wrote in message
news:1cecb01c45319$01757820$a401280a@phx.gbl...
>
> >-----Original Message-----
> >In a report I sort on an ID.  The id's start with 10 and
> >increase by 1 to whatever(10,11,12....).  However when
> >sorted, the report shows
> 10,101,102...109,11,110,111,...119
> >etc. I would like them in sequence. What am I doing
> >wrong?  I reviewed the sorting and grouping.
> >.
> >If this is supposed to be a text field, right justify
> the number and it will sort properly.
Quantcast