Text Fields

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

Guest

If a item is sold in feet a tally item form opens. The salesman then inputs the quantity and number of feet needed for the part number. There may be multiple listings as the following shows.

Part Number 'XXX
QTY: 7.0 @ 45.00 F
QTY: 2.0 @ 32.00 F
QTY: 6.0 @ 12.00 F

This information is stored in a text field used for notes on a quote called 'jd_tallynotes'

I need a way to add up all the quantities in the text box. Is it possible to search each line for a number? I don't want to give each QTY a seperate record.

Thanks
 
Look up the Sum() function in Help. It can be used in
queries, forms or reports as well as in VBA code.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
message
If a item is sold in feet a tally item form opens. The
Click to expand...
salesman then inputs the quantity and number of feet needed
for the part number. There may be multiple listings as the
following shows.
Part Number 'XXX'
QTY: 7.0 @ 45.00 FT
QTY: 2.0 @ 32.00 FT
QTY: 6.0 @ 12.00 FT

This information is stored in a text field used for notes
Click to expand...
on a quote called 'jd_tallynotes'
I need a way to add up all the quantities in the text box.
Click to expand...
Is it possible to search each line for a number? I don't
want to give each QTY a seperate record.
 
In addition to my previous post, "check out 'DSum()' as well
as Sum().

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
message
If a item is sold in feet a tally item form opens. The
Click to expand...
salesman then inputs the quantity and number of feet needed
for the part number. There may be multiple listings as the
following shows.
Part Number 'XXX'
QTY: 7.0 @ 45.00 FT
QTY: 2.0 @ 32.00 FT
QTY: 6.0 @ 12.00 FT

This information is stored in a text field used for notes
Click to expand...
on a quote called 'jd_tallynotes'
I need a way to add up all the quantities in the text box.
Click to expand...
Is it possible to search each line for a number? I don't
want to give each QTY a seperate record.
 
Back
Top