How to

[greysmom06]

I am self-employed and am trying to track compensation for projects. I have
been using Excel but decided to change to Access for the capability of
pulling queries and running reports.

My dilemma is two-fold. First, in creating my table my pay ie for one
contract is 0.006 per word. Access will not show that it rounds to all zeros.

Secondly is regarding comupting within the form. I have created my table
but each project or task I do is paid differently. So I am trying to
multiply pay amount by my total on a form in a EstEarnings.

I have read through help to no avail. I do not get an error message just
blank.

TIA for advice.

 

[John W. Vinson]

I am self-employed and am trying to track compensation for projects. I have
been using Excel but decided to change to Access for the capability of
pulling queries and running reports.

My dilemma is two-fold. First, in creating my table my pay ie for one
contract is 0.006 per word. Access will not show that it rounds to all zeros.

The default Number datatype is Long Integer - and an integer is by definition
a whole number. Since this 0.006 is evidently a currency value (six tenths of
a cent???) I'd suggest using a Currency datatype (not a Currency format, but
the actual datatype in table design).

Secondly is regarding comupting within the form. I have created my table
but each project or task I do is paid differently. So I am trying to
multiply pay amount by my total on a form in a EstEarnings.
I have read through help to no avail. I do not get an error message just
blank.

Please explain what you're doing and how you're doing it. Where is the pay
amount? Where and how are you doing your calculation?

Note that the calculated EstEarnings value should not be stored anywhere in
your table; it can be recalculated as needed.

 

[John W. Vinson]

To add to what John Vinson said about using a currency field, you need to
reset the number of decimal places from auto which is the default to 3 or 4
(assuming you might one day charge .0065). Otherwise it will round to 2
decimal places -- at least it does in Access 2007 and I expect it does in
other versions but I don't have anything else to test with at the moment.

Thanks for the info about A2007 rounding to 2 decimals. That would seem to be
a change - in earlier versions my experience is that Currency holds exactly
four decimals (no more, no fewer). The default *format* is to display two of
those four, so you would indeed want to change the Decimals and Format
properties of the field.