Date Function needed for this Completed Calc.

[corey]

In the Attached file (fmp3) i have a list layout, and a Summary layout.

The summary layout has FINALLY been set up to TOTAL the Values according to the Selection of the Sales Code.

Now i have been told that the SUMMARY needs to ONLY display the Values for any given MONTH/YEAR.

Hence, i ADDED a date field to diaply the MONTH and YEAR.

But problem is, how can i get the result i am now after?

I tried to add an IF()DATE calc. to the existing CALC, with NO LUCK.

Layout 4 is where i got up to, can anyone help with this.

Just needs to show the Calculated values of the Summary Layout, BUT According to the MONTH requested.

Thnx in advance.

Corey....

SA.zip

[McCormick]

If I understand this correctly, you need to use a scripted or manual search.

If you do a search of any sort, your Total fields will give you totals of only the records in the Found Set. So if you search for July, you will see the figures that apply only to July.

If you don't want to do a script, you can disregard this. If you do, hopefully it will solve your problem in one step. You can search the date field for "7/1/2003...7/31/2003". It might be easier to have a new field, Month, that is just a calc of MonthName(Date). Then users can type "July" or "Aug". I use a Month field and a Year field nex to each other, so I type "Jul" in one and then "03" in the other, which I find easiest.

You could have a button that goes to the summary field, but first pauses on a different layout to let a user enter the date information they want. Or you could use the Show Custom Dialogue script step to accept information that way.

Depending on your needs, you can keep getting fancier, with Next Month and Last Month buttons, etc.