Jasper

Thanks a lot guys! I think I've got this working properly now. I've incorporated the STATUS(CurrentDate) as suggested in the post prior to this and it is giving me the dates I wanted so far. I'll keep checking it daily to make sure the formulas are true. JESSE

Thanks for the new inputs guys! I am just using a normal field with the AutoEnterCalc set with the TODAY function as my primary date field and have it showing the DAY and DATE. My WeekEnding field uses that in its calculations. I'll try a temporary fied and see if the CASE formula will work as needed, but I'll need to go a couple of days on it to proof it out. I'll get back with the results. THANKS!!! JESSE

Queue I'm still having problems working out the solution to the Week Ending Date! For instance, I input your formula and today being May 25, the Week Ending Date should be Friday May 28, and your solution gives the date of May 5, 2004. Any new suggestions? I am just not good with DATE calcs at all. I tried your solution and get a date, however, it is not the weekending date for the week listed. Here's how the system dates the days - on the left and how my new week starts out - on the right: Sunday = 1 Saturday = 7 Monday = 2 Sunday = 1 Tuesday = 3 Monday = 2 Wednesday = 4 Tuesday = 3 Thursday = 5 Wednesday = 4 Friday = 6 Thursday = 5 Saturday = 7 Friday = 6 Friday, being payday, - hence Sat. being the first day of the new week, which means that it compounds the calculation. I did get one to work about as close as yours, however, my date moves to different days also. My formula is IF(DayofWeek(datefield)=1,DayofWeek(Today) + 5, "Error")) - DayofWeek(Today) + 731724 I need to keep incrementing the date as today, May 25, I am getting the result of Thursday, May 20 as the Week Ending date. Any help, comments, suggestions will be greatly appreciated. JESSE

YES, I have 50+ records of ONE field, each field with 5 Radio buttons. I'm amazed. I actually did get something to work on these records by using a COUNT and an IF statement in conjunction as shown below in five extra fields as one of you stated: IF( (BSI_01=0), Count(BSI_01),"") + IF( (BSI_02=0), Count(BSI_02),"") --- etc., etc. Actually this was fairly easy as I copied one formula, pasted it many times and the formulas lined up quite nicely so that I had little trouble changing the field names. After this I added another 5 fields for weighting the selections PLUS another for a grand total of all weighted factors. This may be a lengthy process - I'm NOT a whiz at this - but it works very well. I don't know if it would work on repeating fields or not, however, if someone has a problem with those they might try it out. Thanks much for responding! It helped with the brain block. JESSE

A friend has a file that uses 50+ rows of just one field consisting of 5 radio buttons as shown below. Using fields F0-F4, I am tring to calculate the total number of entries for each radio button underneath the rows. I played around with this for some time using the Count function and various attributes, however, I either got a total of the number of rows or a zero. I could not discriminate between those buttons selected and those left blank. Any help would be greatly appreciated. Database: O0 - O1 - O2 - O3, O4 (O's represent buttons - 50 + rows of these same fields with unique names) ======================= Calculations: F0 - F1 - F2 - F3 - F4 Thanks, JESSE

I'm trying to set up a field that will "find" a week ending date (Fridays) that will display. I already have a function showing the CURRENT DATE - with day of the week and date displayed - if the date is required in a calcuation field. Any help, hints, tips would be appreciated. JESSE

Why not just use a glaring button that says "NEXT" and have it run a script to the next layout?? That may take SOME effort on the users part, but if your users cannot handle that you may have more important problems with user input than that. JESSE

Using FMP 5.5 I tried the Preview + Ctrl C routine and pasting into the body of an eMail in Outlook Express 6 and each time the COPY is lost, so therefore will not paste. Any ideas as to why not? JESSE