Re: 2nd post?:Totalling / counting entries within a field

To further clarify, <orders> is a single field where the data is probably
not tab or comma delimited. I am getting the data into the field by
clicking on a related table for each package. It copies and pastes the
related package number into the <order> field. I could force it to enter
<order&","> if that would help.
Thanks,
KS
"Matt Wills" <Im@xxxxxxxx> wrote in message
news:Im-6225F6.10435631082006@xxxxxxxxxxxxxxxxxxx
Using the example provided, is <orders> three separate records, or is it
a single record with three return-separated values?

Matt

In article <S4Wdnc8FMZNvUWvZnZ2dnUVZ_oydnZ2d@xxxxxxxxxxxx>,
"KennyS" <ks4078@xxxxxxxxxxx> wrote:

Pardon me if this post has alreay appeared. I posted it a couple of days
ago but I'm not seeing it or any replies on my computer.

I have a FM 8 database with a field called 'orders'

In 'orders' are the numbers of the packages that were ordered. ie:
12/3/17/17
The example shows that the customer ordered 1 of package 12, 1 of package
3
and 2 of package 17.

I have hundreds of files. I have a total of 26 packages to choose from.

I would like to be able to calculate how many of each package was ordered
for a range of customers.

Using the following 3 orders as an example, can you tell me the
calculation
that I would need to accomplish this task?

#1) 3/4/4
#2) 3/5/5/12
#3) 6/7/7/7/10

I would like the calculation would return something like the following:

Package number Total
3 2
4 2
5 2
6 1
7 3
10 1
12 1

Thanks in advance.

Kenny


.

Relevant Pages

  • Re: 2nd post?:Totalling / counting entries within a field
    ... concatenating it into a single field is actually ... really needed was a summary of total for each package number, ... I would like the calculation would return something like the ...
    (comp.databases.filemaker)
  • Re: 2nd post?:Totalling / counting entries within a field
    ... It is a single field ... ago but I'm not seeing it or any replies on my computer. ... I would like to be able to calculate how many of each package was ordered ... I would like the calculation would return something like the following: ...
    (comp.databases.filemaker)
  • Re: TOTAL package PER DAY AND PER HOUR
    ... i want to calculate the total per day" total package /30" and the ... you can't use a newly calculated fieldname in a further calculation. ... You'll need to either recapitulate the entire expression, or save the query ...
    (microsoft.public.access.forms)
  • Re: 2nd post?:Totalling / counting entries within a field
    ... You would be much better off if it was three separate related records, ... but you might still be able to do something with the PatternCount ... I would like to be able to calculate how many of each package was ordered ... I would like the calculation would return something like the following: ...
    (comp.databases.filemaker)
  • Re: [tikz] problems drawing filled arc
    ... Anyway, I try to perform some calculation now but I can't get it, see ... The idea is to use the FP package and macros/commands ... Paul Gaborit - ...
    (comp.text.tex)