Using weight (pounds/ounces) in Access database

[Guest]

I am setting up a database to keep track of fish I catch. I am stumped at the
weight factor. Usual fishing jargon uses pounds/ounces, for example: I caught
a 3-4 means a three pound four ouncer - not 3.4 pounds. I want Access to
"see" 3-4 as pounds/ounces and be able to total or whatever just as you would
regular numbers in Excell or Access. I am using Office 2000.

 

[James McNellis]

Your best bet would be to convert the number to ounces when you store it,
then convert it back to your desired format when you display it. There are
16 ounces in a pound, so when storing it you could use (16 * pounds) +
ounces.

You could create two fields or use a text field, but that would be no easier
than this solution.

Cheers--

James.