Re: fraction number format?

From: "ManningFan" <manningfan@xxxxxxxxx>
Date: 30 Jun 2006 13:22:49 -0700

Look into CHR$(). I know there are ASCII characters that will diplay
fractions, and you can return the values to a form or report using an
"IIF" statement (i.e.:

IIF(MyVal = "0.5", CHR$(x), MyVal)

or something along those lines.

.

References:
- fraction number format?
  - From: Richard Hollenbeck

Prev by Date: Re: Sending a Pivot Table by Mail
Next by Date: Re: More on "cannot open another database" error
Previous by thread: Re: fraction number format?
Next by thread: Create a multiple parameter search form for a query
Index(es):
- Date
- Thread

Relevant Pages

Re: For Marshall Barton
... You really have changed the names od the subreport ... As for your report picking up more data than you want. ... After fixing the IIf problem, ... Control Source: ABegBal ...
(microsoft.public.access.reports)
Re: For Marshall Barton
... However, when I ran the report, it kept ... After fixing the IIf problem, ... Control Source: ABegBal ... "The LEVEL clause includes a reserved word or argument that is misspelled or ...
(microsoft.public.access.reports)
Re: Using the IsError Function
... On a report, may refer to a control. ... A control may be missing if a section is missing: ... The VBA IIF is slightly different from the Jet SQL IIF. ...
(microsoft.public.access.reports)
Print parameters or default value
... format on the report by adding to an unbound text ... would be printed on the report. ... same report to contain a concatenated value: [PartNum1] ... I can sort of imagine nested IIf ...
(microsoft.public.access.reports)
Re: Summing time
... Did you read any of my comments and/or recommendations? ... My goal is to get a report to show each ... not Iif. ... not use the calculated column in another calculation. ...
(microsoft.public.access.reports)