Prev: Strange Problem With DoCmd.OutputTo When Generating a PDF File.
Next: Report Shows ID instead of Text
From: Mommybear on 28 Apr 2010 14:09
I have a report that is sorted by Floor, Department, then by Room. My floors
are 1-12. In order to get them to sort properly I have them in the database
as: 01, 02, 03, etc else they sort like this 1, 10, 11, 12, 2, 3, etc.

These are showing on my report as:
01, 02, 03, etc and I only want them to appear as a single digit, 1, 2, 3,
etc. I tried setting the format to ## but it still shows the leading zero.

Any suggestions.

Dawn
From: Duane Hookom on 28 Apr 2010 15:12
You can wrap the Floor field in the Val() function. This would also aid in
sorting since the Val() of 2 would sort before the Val() of 13.

--
Duane Hookom
Microsoft Access MVP


"Mommybear" wrote:

> I have a report that is sorted by Floor, Department, then by Room. My floors
> are 1-12. In order to get them to sort properly I have them in the database
> as: 01, 02, 03, etc else they sort like this 1, 10, 11, 12, 2, 3, etc.
>
> These are showing on my report as:
> 01, 02, 03, etc and I only want them to appear as a single digit, 1, 2, 3,
> etc. I tried setting the format to ## but it still shows the leading zero.
>
> Any suggestions.
>
> Dawn
From: Mommybear on 28 Apr 2010 16:19
Doing this gave me a result of #### in my report. I did forget to mention
that my format was text and not numeric. When I tried to change the format,
I got a "not enough space" error. I have over 33k records. I do have some
alphanumeric values as well (B1, B2). Which should be sorting first. "Duane
Hookom" wrote:

> You can wrap the Floor field in the Val() function. This would also aid in
> sorting since the Val() of 2 would sort before the Val() of 13.
>
> --
> Duane Hookom
> Microsoft Access MVP
>
>
> "Mommybear" wrote:
>
> > I have a report that is sorted by Floor, Department, then by Room. My floors
> > are 1-12. In order to get them to sort properly I have them in the database
> > as: 01, 02, 03, etc else they sort like this 1, 10, 11, 12, 2, 3, etc.
> >
> > These are showing on my report as:
> > 01, 02, 03, etc and I only want them to appear as a single digit, 1, 2, 3,
> > etc. I tried setting the format to ## but it still shows the leading zero.
> >
> > Any suggestions.
> >
> > Dawn
From: Duane Hookom on 28 Apr 2010 21:28
Did you change the name of the text box? You can't have a text box named
"Floor" with a control source like:
=Valu(Floor)

--
Duane Hookom
MS Access MVP


"Mommybear" <Mommybear(a)discussions.microsoft.com> wrote in message
news:14DC802B-7BD5-46B7-834F-9A317B323143(a)microsoft.com...
> Doing this gave me a result of #### in my report. I did forget to mention
> that my format was text and not numeric. When I tried to change the
> format,
> I got a "not enough space" error. I have over 33k records. I do have
> some
> alphanumeric values as well (B1, B2). Which should be sorting first.
> "Duane
> Hookom" wrote:
>
>> You can wrap the Floor field in the Val() function. This would also aid
>> in
>> sorting since the Val() of 2 would sort before the Val() of 13.
>>
>> --
>> Duane Hookom
>> Microsoft Access MVP
>>
>>
>> "Mommybear" wrote:
>>
>> > I have a report that is sorted by Floor, Department, then by Room. My
>> > floors
>> > are 1-12. In order to get them to sort properly I have them in the
>> > database
>> > as: 01, 02, 03, etc else they sort like this 1, 10, 11, 12, 2, 3,
>> > etc.
>> >
>> > These are showing on my report as:
>> > 01, 02, 03, etc and I only want them to appear as a single digit, 1,
>> > 2, 3,
>> > etc. I tried setting the format to ## but it still shows the leading
>> > zero.
>> >
>> > Any suggestions.
>> >
>> > Dawn

From: Mommybear on 29 Apr 2010 13:42
Floors 1-9 worked great however, 10, 11, 12, were excluded and B1 and B2
appeared as an Error as did the floors with no value.


"Duane Hookom" wrote:

> Did you change the name of the text box? You can't have a text box named
> "Floor" with a control source like:
> =Valu(Floor)
>
> --
> Duane Hookom
> MS Access MVP
>
>
> "Mommybear" <Mommybear(a)discussions.microsoft.com> wrote in message
> news:14DC802B-7BD5-46B7-834F-9A317B323143(a)microsoft.com...
> > Doing this gave me a result of #### in my report. I did forget to mention
> > that my format was text and not numeric. When I tried to change the
> > format,
> > I got a "not enough space" error. I have over 33k records. I do have
> > some
> > alphanumeric values as well (B1, B2). Which should be sorting first.
> > "Duane
> > Hookom" wrote:
> >
> >> You can wrap the Floor field in the Val() function. This would also aid
> >> in
> >> sorting since the Val() of 2 would sort before the Val() of 13.
> >>
> >> --
> >> Duane Hookom
> >> Microsoft Access MVP
> >>
> >>
> >> "Mommybear" wrote:
> >>
> >> > I have a report that is sorted by Floor, Department, then by Room. My
> >> > floors
> >> > are 1-12. In order to get them to sort properly I have them in the
> >> > database
> >> > as: 01, 02, 03, etc else they sort like this 1, 10, 11, 12, 2, 3,
> >> > etc.
> >> >
> >> > These are showing on my report as:
> >> > 01, 02, 03, etc and I only want them to appear as a single digit, 1,
> >> > 2, 3,
> >> > etc. I tried setting the format to ## but it still shows the leading
> >> > zero.
> >> >
> >> > Any suggestions.
> >> >
> >> > Dawn
>
 |  Next  |  Last
Pages: 1 2
Prev: Strange Problem With DoCmd.OutputTo When Generating a PDF File.
Next: Report Shows ID instead of Text