Datasheet Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello Everyone!

I have a database with Cost Centers and Amounts I would like to know if
there is a way to create a field in a datasheet view so I can list more then
one cost center in the field and the same for the amount field WITHOUT
creating a subform. Any ideas?

Thanks!!

Doug
 
1. Never use 1 field to hold multiple values. I strongly suggest you drop
that idea.

2. A poor, but possible solution is to create fields CCenter1, CCenter2,
etc... and CCAmt1, CCAmt2, etc... You must be positive that you'll never
need more than 3 or 4 of these values... EVER... and... it does make
reporting, querying, adding, and otherwise operating on those CC values
clumsy and difficult. This is a do-able, but a "I wish I hadn't done it
that way." solution.

3. As you probably know, the best solution would be a realted table
containing a link field, CCenter and CCAmt fields, used in a subform, to
allow multiple CC entries against a particular record. This method allows
for much easier "analysis" of your CC data, and makes the subform... in the
end... the best solution.
hth
Al Camp
 
Hi Al,

Correct, that's the way I have it set up current;y using the subform. I want
to add on the mian form a field that would perform a running total from the
amount field in the subform like a check sort of speak. As users enter the
different amount in the Amount field, I wanted to a field to total that sum
so they can see if it matches the Total Invoice Amount filed on the main
form. This way, if the two fields Total Invoice and the running total field
didn't match, they could go back and correct any errors before going to a new
record. I have tried to make a running total field work buit with no luck at
all. I thought going the other way it would be easier but I know will create
more problems than it's worth. Any suggestions?

Thanks!!

Doug
 
Hi Al,

It worked! Thank you so much for help, your the greatest!

Doug

Al Camp said:
Doug... pardon the incomplete reply... a finger check


In your subform... in the form footer, a text field, called TotalAmount
with
=Sum(AmountField)
will yield the total of all the AmountFields in the subform, as long as they
are bound fields.

Then, a field on the main form with...
=[Forms]![frmYourMain]![frmYourSubform].[Form]![TotalAmount]
will always display the TotalAmount value from yoyr sub.
hth
Al Camp

Doug_C said:
Hi Al,

Correct, that's the way I have it set up current;y using the subform. I
want
to add on the mian form a field that would perform a running total from
the
amount field in the subform like a check sort of speak. As users enter the
different amount in the Amount field, I wanted to a field to total that
sum
so they can see if it matches the Total Invoice Amount filed on the main
form. This way, if the two fields Total Invoice and the running total
field
didn't match, they could go back and correct any errors before going to a
new
record. I have tried to make a running total field work buit with no luck
at
all. I thought going the other way it would be easier but I know will
create
more problems than it's worth. Any suggestions?

Thanks!!

Doug
Click to expand...
Click to expand...
 
Back
Top