roqueredonde

Well what could I say ? This seems to produce the result Thank you ! Now, for sure, it is going to take me sometime to understand all your tricks to be able to reuse your solution in my db. But, hey, whatelse could I ask ?! Really smart ! Thanks again !

the max is more around 30 days (a month to say)

the other answers ... re 1) No the booking is for one person. ie one name <==> one seat re 2) I like this idea of running balance. And I guess I shall be able to set a starting balance (or find a way to let the user provide it ?) thanks again

re a): yes the range does not have to be infinite. So a limit is fine. re :: yes. I did have the feeling another table was needed, but I could not see how to relate them. thanks for trying to help me !

Well I guess my question is either in the wrong forum, or too incomprehensible, or too complex ... Can't one of the experts just tell me yes, or forget about it, hello ... any help ... thanks

Hello, I'm new to FM, so please excuse my question if you think it's really stupid, or should be asked in a different forum. I'm using FM 5.5. I have a table which could be sumup to the following fields: - name: name of a person - book in date: date the person should arrive - book out date: date the person should leave - check in date: the actual date the person arrived - check out date: the actual date the person left I would like to build report on a date period (range from date1 to date2), which will return something like: Date ....... Book IN . Book OUT . Check IN . Check OUT . Present forecast . Present real 01/01/2005 ..... 2 .......... 0 .................... 1 .................... 0 .................. 2 ....................... 1 02/01/2005 ..... 5 .......... 1 .................... 6 .................... 0 .................. 6 ....................... 7 03/01/2005 ..... 3 .......... 2 .................... 4 .................... 2 .................. 7 ....................... 9 04/01/2005 ..... 1 .......... 5 .................... 0 .................... 4 .................. 3 ....................... 10 up to date2... This could be understood as a reservation system of a camp ground (let say unlimited space ...). And I need to know : - what were/is/will be the forecast of in and out - what was/is the actual check in and out - how filled up it was/is/will be on a daily basis, for past dates, today, future dates ... So I'm wondering if I could do that with a simple report, or I hope I'm clear enough... Thanks in advance for your suggestions. Have a good day,