Hi,

I have much of my database experience with Access, and I hope to be able 
to do some stuff with FileMaker.  Not so obvious yet...

How do I get a field that will give me the sum of the value of all 
records in one field?  In Access, I could just put an unbound field with 
sum(FieldName) in the record source.

Or I could write a SQL query like 
select sum(fieldname)
from tablename

However, with filemaker I am stuck. 

Anyone can help?  Thanks

Michel

Michel,

You have to create a relationship from the file/table to itself (a 
self-join) and then apply the sum() function to the related field. The 
FileMaker help is pretty good on this one.

Jeroen Aarts

*-*-*-*-*-*-*-*-*-*-*
Tasty Bytes
www.tastybytes.be
*-*-*-*-*-*-*-*-*-*-*


"alvb" <midion821@REMOVErogers.ca> wrote in message 
news:midion821-FEF811.07011723042005@news.isp.giganews.com...
> Hi,
>
> I have much of my database experience with Access, and I hope to be able
> to do some stuff with FileMaker.  Not so obvious yet...
>
> How do I get a field that will give me the sum of the value of all
> records in one field?  In Access, I could just put an unbound field with
> sum(FieldName) in the record source.
>
> Or I could write a SQL query like
> select sum(fieldname)
> from tablename
>
> However, with filemaker I am stuck.
>
> Anyone can help?  Thanks
>
> Michel 

Hello,  

Thanks.  OK, I will do that.  I am also very open to reading the 
manual/documentation.  I am still stuck in the MS Access framework, but 
I think FileMaker is still somewhat strong enough.  Could you tell me 
more specifically where in the help in could find info on this topic.

Michel

In article <426a65eb$0$7753$ba620e4c@news.skynet.be>,
 "Jeroen Aarts" <jeraarts@NSantwerpen.be> wrote:

> Michel,
> 
> You have to create a relationship from the file/table to itself (a 
> self-join) and then apply the sum() function to the related field. The 
> FileMaker help is pretty good on this one.
> 
> Jeroen Aarts
> 
> *-*-*-*-*-*-*-*-*-*-*
> Tasty Bytes
> www.tastybytes.be
> *-*-*-*-*-*-*-*-*-*-*
> 
> 
> "alvb" <midion821@REMOVErogers.ca> wrote in message 
> news:midion821-FEF811.07011723042005@news.isp.giganews.com...
> > Hi,
> >
> > I have much of my database experience with Access, and I hope to be able
> > to do some stuff with FileMaker.  Not so obvious yet...
> >
> > How do I get a field that will give me the sum of the value of all
> > records in one field?  In Access, I could just put an unbound field with
> > sum(FieldName) in the record source.
> >
> > Or I could write a SQL query like
> > select sum(fieldname)
> > from tablename
> >
> > However, with filemaker I am stuck.
> >
> > Anyone can help?  Thanks
> >
> > Michel

Just pull open the "help" menu, choose "FileMaker Help" and search "sum()" 
;-)

You will see that if the argument of the sum() function is a related field, 
the result is the sum of all the related values. To get the sum of the 
values of all records of a file/table, you have to create a so-called 
"constant" relationship (FMP <7) or a "cross-product" relationship (FMP 7). 
Do a search in the posts of this newsgroup and you sure will find usefull 
information about this topic.


HTH


Jeroen Aarts

*-*-*-*-*-*-*-*-*-*-*
Tasty Bytes
 www.tastybytes.be
*-*-*-*-*-*-*-*-*-*-*






"alvb" <midion821@REMOVErogers.ca> wrote in message 
news:midion821-F5D2AB.16212223042005@news.isp.giganews.com...
> Hello,
>
> Thanks.  OK, I will do that.  I am also very open to reading the
> manual/documentation.  I am still stuck in the MS Access framework, but
> I think FileMaker is still somewhat strong enough.  Could you tell me
> more specifically where in the help in could find info on this topic.
>
> Michel
>
> In article <426a65eb$0$7753$ba620e4c@news.skynet.be>,
> "Jeroen Aarts" <jeraarts@NSantwerpen.be> wrote:
>
>> Michel,
>>
>> You have to create a relationship from the file/table to itself (a
>> self-join) and then apply the sum() function to the related field. The
>> FileMaker help is pretty good on this one.
>>
>> Jeroen Aarts
>>
>> *-*-*-*-*-*-*-*-*-*-*
>> Tasty Bytes
>> www.tastybytes.be
>> *-*-*-*-*-*-*-*-*-*-*
>>
>>
>> "alvb" <midion821@REMOVErogers.ca> wrote in message
>> news:midion821-FEF811.07011723042005@news.isp.giganews.com...
>> > Hi,
>> >
>> > I have much of my database experience with Access, and I hope to be 
>> > able
>> > to do some stuff with FileMaker.  Not so obvious yet...
>> >
>> > How do I get a field that will give me the sum of the value of all
>> > records in one field?  In Access, I could just put an unbound field 
>> > with
>> > sum(FieldName) in the record source.
>> >
>> > Or I could write a SQL query like
>> > select sum(fieldname)
>> > from tablename
>> >
>> > However, with filemaker I am stuck.
>> >
>> > Anyone can help?  Thanks
>> >
>> > Michel 

Help -> Filemaker Help -> Search tab

enter "Sum"

First match: "Sum function"

Type in 
In article <midion821-F5D2AB.16212223042005@news.isp.giganews.com>, 
midion821@REMOVErogers.ca says...
> Hello,  
> 
> Thanks.  OK, I will do that.  I am also very open to reading the 
> manual/documentation.  I am still stuck in the MS Access framework, but 
> I think FileMaker is still somewhat strong enough.  Could you tell me 
> more specifically where in the help in could find info on this topic.
> 
> Michel
> 
> In article <426a65eb$0$7753$ba620e4c@news.skynet.be>,
>  "Jeroen Aarts" <jeraarts@NSantwerpen.be> wrote:
> 
> > Michel,
> > 
> > You have to create a relationship from the file/table to itself (a 
> > self-join) and then apply the sum() function to the related field. The 
> > FileMaker help is pretty good on this one.
> > 
> > Jeroen Aarts
> > 
> > *-*-*-*-*-*-*-*-*-*-*
> > Tasty Bytes
> > www.tastybytes.be
> > *-*-*-*-*-*-*-*-*-*-*
> > 
> > 
> > "alvb" <midion821@REMOVErogers.ca> wrote in message 
> > news:midion821-FEF811.07011723042005@news.isp.giganews.com...
> > > Hi,
> > >
> > > I have much of my database experience with Access, and I hope to be able
> > > to do some stuff with FileMaker.  Not so obvious yet...
> > >
> > > How do I get a field that will give me the sum of the value of all
> > > records in one field?  In Access, I could just put an unbound field with
> > > sum(FieldName) in the record source.
> > >
> > > Or I could write a SQL query like
> > > select sum(fieldname)
> > > from tablename
> > >
> > > However, with filemaker I am stuck.
> > >
> > > Anyone can help?  Thanks
> > >
> > > Michel
>