Matteo

Hi all, Here is my situation. I have made a FM file to keep track of the project and users that are using my lab. Here are the main fields: UserName ProjectID Belongto: Valuelist= InsideUniv, OutSideUniv, Companies. Formatted as a radio button list Status: Past, Actual, Potential The problem is that there could more than one user per project and also a user can have more than one project going on. thus, when I do simple summary counting, I don't get the right number of users or project but I've solve that by creating a valuelist out of UserName field and count the items. But, I'd like to count the number of Past, actual, and potential project as well as the number of insideuniv, ousideuniv and companies project. I've been struggling to find a solution without success. Best would be to have the calculation results during browsing but in report it would be ok too. Is there a solution to that ? Or do I need to rebuild my DB in an other way (one file for users, one file for project). Thanks a lot in advance. Matteo

Sorry I just got my answer.... Create a field for each value (past, actual and future) and count using patterncount ( FieldList, "past"). Then display the total using a summary field = Total of (patternCount(...)) Sorry for disturbing...

Hi all, My problem is the following: I have a field which is related to a list made of three items let's say "past", "actual" and "future". I'd like to count the number of record where "Past" is selected, as well as the number of record where "actual" is selected etc... Could someone help me ? Thanks Matteo