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

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: 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
    ... 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: 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
    ... 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)