Hi,

I am trying to create a summary of items that are marked "OK for Press" during a certain time frame range. Ideally, I'd like to be able to view a summary page that would tell me how many items were approved for each week. I tried this calculation that is then counted in a summary field, but it's not working:

If (approved = "OK for Press";1;0) & (approval_date = Date ( 2 ; 11 ; 2008 ) & "..." & Date ( 2 ; 17 ; 2008 ) )

Thanks in advance for all of your help! I appreciate it! These boards are great.

Try this.

approved = "OK for Press" and approval_date >= Date ( 2 ; 11 ; 2008 ) and approval_date <= Date ( 2 ; 17 ; 2008 )

It's not good practice to hard-code dates (or any data) into calculations. What will you do next week?

Why don't you either find the records that meet the criteria, or define a relationship that filters the related items by the same criteria (use a calculation field = "OK for Press", and two more calculation fields to get the current week's firat and last day).

thanks very much mr vodka and comment! I will give your solutions a try.

there were only a couple weeks that I needed to pull, so I was going to hard code them - but I know that's a big no-no! Comment, you are right, what if things come up later than the weeks I needed?

thank you again, will report back!

Update! I had to use the hard coding option since I needed to get the info available to everyone asap. It works well! I am however working on a non-hard coded solution in my spare time. Thanks again for the help.