wallaby

Hi Thank to the ZIP file from Comment, I got an Idea how to count things together from a Value List. I'm actually just looking for something like that : I do have a question: Is it possible to count different Values for each group together? Something like this: Lets say I've got a ValueList: A B C D Entered Numbers in A (Numbers means a Currency): 12.00, 10.00 Entered Numbers in B: 100.00, 5.00 So is it possible to get a List out, which counts the value together from each ValueList? => A = 22.00 => B = 105.00 => C = 0.00 => D = 0.00 I didn't find a solution to SUM those values up or I do miss something here. I tried to modify the "sumByCategorySimple.fp7.zip", but doing something wrong. Thanks for any help :)

Hi gbrozak, It would be nice to be able to follow/see your problem. Because I have similar problems and I guess I'm not the only one, am I? So it would be great if you could share your file. Since my english is not so good, an example file is always good to look at :

Oh, yes, that was it Thank you very much, sbg2. Now I just need to see how I can get the total summary of the appropriate ListValue. Thank you very much again, sbg2.

Hi I'm new at FM and I'm blocked again. I didn't find a solution so far, regardless what I tried. And after searching fmForums 3 days, I thought I'll give it a try. May be it's very simple and I'm just looking too far? I have a Value List filled with different Items (in my file called "Kostenstellen"). My idea is to have now on the "Matrix"-Tab a Summary, where it pulls out all Items from the Value List once and shows also on the left side the total of the Costs (total from "AUS Zahlenwert"). Additional: Best would be of course if I could add a search to show it by years (lets say 2006) like I made on the Tab "Listen", where I can sort/filter by month/years. So far I haven't been able to even get out the Value List into a Portal or Textfield. Is that possibe from a Value List? If yes, how? I hope my english was clear enough? Thank you very much for your help. _ValueList.zip

Wow, thanks Fenton!! I was trying all sort of stuff the whole day today again, but nothing did work. Since I'm new in FM, I never would have found the solution. Thank you very much!! Yes, you are right with the popup window. I actually even thought that I wanna make a popup window which can be closed by a button. So you even showed me my next step : Thanks for your time to help me out!

*************************** Update January 15th, 2006 *************************** I think I have found the answer to Question 1. thanks to the Forum Entry I have found here. And I'd like to share if someone is interested : I used a "Set Variabe" with "==*" to find all Records which are not empty. Still searching the answer for Question 2, so if anybody has an idea how to solve would be appreciated : _FindRecords.zip

Hi After searching days and trying out several codings, I still do haven't found any answer for two question: 1. Question =========== I'm trying to find all records "AUS Kostenstelle" for "Natel" in "2006" and show ALL records in "2006" which have anything filled out in "EIN Kostenstelle". So something like this: Find Records -> Budget::AUS Kostenstellen: [Natel] AND Budget::cYear [2006] Find Records -> Budget::EIN Kostenstellen: [==*] AND Budget::cYear [2006] I somehow can't find the solution to get all records for "EIN Kostenstellen" if there is anything entered. 2. Question =========== On the "Liste" Tab, I do have a GIF "i" for Information, which leeds to the appropriate record. Is there a way to show this "i-GIF" only on the right side, IF there was entered any Comment (Bemerkung) from the Tab "Eintrag"? So if there is nothing in the "Bemerkung", the Information-GIF won't be shown. Is that possible? Does anybody know an idea how to solve my problems? Or if Question 2 is possible? Thank you very much for your help :(

Hi Thank you very much Breezer and Raybaudi for your very fast reply! It's working and I think because of you I'll have a good night tonight (withouth thinking about this problem Thanks very, very much )

Hi First of all, I'm new and I'm sorry for my english... its not my nativ language. So I hope I can make myself clear here : Since I was searching this forum for several days and tried out different things, I thought I'll ask here since I still didnt't get to work it. The idea is of a basic Budget Template for myself (this way I thought I can get into FileMaker and can design my own Layout Question: I have 3 fields (dropdown boxes): - Income ("Einkommen") - Expenses ("Ausgaben") - Year Now I want to make a search to for expl show all records with the date "2006". (I got that so far) But how do I now resarch (narrow) this Find Result (without loosing it) to show all records that have Ausgaben = Natel Einkommen = Lohn (sorry that those are in German... but my ZIP file is in German as well, so I thought you see which Field I mean.) As I see, it should be an OR search, but in Perform Find I'll see, that it is only an AND search, which gives me (of course) a wrong result. I have attached the ZIP file to show you my problem. The search in "Liste" works so far and also the search by "Date to Date" (thanks to this forum ) So how should I perform this search (narrow) so I get all Records which have the Date 2006 AND (Einkommen = "Lohn" OR Ausgaben = "Natel")? Thanks very much for any help. I hope I was able to make myself clear here : FindRecord.zip