Here is what I am facing. Please let me know if this is possible.
Table A has 3 fields that are dollar amounts and only 1 of these 3 fields will have an entry.
Then I have Table B that has one field that need the dollar amout in it from one of the 3 fields in table A.
I have all these fields set up on a form, with a query connecting the two tables.
So is it possible to auto fill the field in table B with one of the 3 fields from table A based on whether or not there is a value in one of the other 3 fields.
I hope this makes sense. Thanks!