How do I enter fractions in Access

[Guest]

I would like to multiply inches with fraction (24 1/2" x 25" ) in access. I
want to create one column for width and one for length and then a column with
the answer (612.50 inches).

 

[Naresh Nichani MVP]

Hi:

In general you do not create a calculated column as a field in an Access
table.

It is better to calculate the result with a query or display as a calculated
field on form or report. You could have fields "Width" and "Length" in table
and designa query with fields Width, Length and a new columns called say
Answer which does your calculation in the query window type this
Answer:[Width]*[Length]
Here Answer is the calculated column name follow this with a colon ). Then
type each field name with square brackets and use appropriate math symbols
to get the result.

You can use a Query as a source for Form or Report as well. The calcualted
field cannot be edited on form and will show read only.

Regards,

Naresh Nichani
Microsoft Access MVP

 

[Guest]

In addition to the above reply: How are your numbers stored? Is your
fraction in its own field or is it part of a text field containing the entire
24 1/2? In order to calculate on it it would need to be converted to a value
so that 1 is actually divided by 2 which can be done by parsing out the
fraction.

Can you be more specific on the field structure?

Hi:

In general you do not create a calculated column as a field in an Access
table.

It is better to calculate the result with a query or display as a calculated
field on form or report. You could have fields "Width" and "Length" in table
and designa query with fields Width, Length and a new columns called say
Answer which does your calculation in the query window type this
Answer:[Width]*[Length]
Here Answer is the calculated column name follow this with a colon ). Then
type each field name with square brackets and use appropriate math symbols
to get the result.

You can use a Query as a source for Form or Report as well. The calcualted
field cannot be edited on form and will show read only.

Regards,

Naresh Nichani
Microsoft Access MVP

I would like to multiply inches with fraction (24 1/2" x 25" ) in access. I
want to create one column for width and one for length and then a column with
the answer (612.50 inches).