how to...??

[apolivo]

Is it possible, using datafilter, to get (in my example) all of the treatment dates per name per given period in a seperate file?

In my file "Invoeren Datums", you can find all of the given treatments as seperate records. This file is linked to another file "Patienten".

The meaning of my question is to create invoices for one with a summary of all their treatments within a given period.

I 'll enclose hereby the files.

Thanks for helping me out of this...

InvoerenDatums.zip

[Søren Dyhr]

You need to upload both files - please do! If patients confidentiallity are at stake here make some dummies!!

--sd

[apolivo]

Hi - Thanks for that quick reply and mentioning that i forgot to upload the related file.

Still hope someone can help me.

Hereby the forgotten file.

1100522997-Patiënten.fp5.zip

[Lee Smith]

Hi apolivo,

Only one file came through (Patie

[apolivo]

Hi Lee, thanks for your reply. My trials to upload the files doens't seem to work quite well...

With this reply, I'll send now an archive of the three requested files.

Thanks for some help...

Yves

Files.zip

[Søren Dyhr]

Right, you need either to make a calc'field in both files Month(theDate) and relate these two fields to each other if you only invoice clients on a monthly basis. If some clients should have shorter or longer credit must a multilinekey be made from the fromDate and toDate fields, that makes all the dates in between either by a hashing algorithm like Edoshins Smartranges or simply by a calcfield ...this will make the relation key to Sum( over.

--sd