Hey everyone, I hope you can help. I have created a simple database for
our clinic with medical codes and so forth. The Nurse needs to be able
to run a daily and monthly report. I have created a layout that
contains a count of each selected field. This will show the grand
total, but how can I set it up so she can get a count for only a
specified date range. Any help would be greatly appreciated! Thanks.

jerthebear wrote on (11/1/2005):

The find code for a range is "..."

For instance, to get all of the month just past, in your find, enter
10/1/2005...10/31/2005.

Of course, the Nurse would probably appreciate it if you scripted that
after he selected the desired month..

Matt

--

jerthebear wrote:
If you are using FM7/8 you can create a rel using multiple criteria:
two globals both pointing to your date target

g_DateFrom <= DATE
g_DateTo >= DATE

Alternately you can create a calc in the target table that returns the
month and year
Month(Date) &" " & Year (Date) & "¶" & Month(Date) & "¶" & Year(Date) &
"¶" & "All" & "¶"
this returns somthing like:
11 2005
11
2005
All

then use two globals to nominate the Month and year you want to return.
Attach a value list to the month global, using the following

All Months
-
1
2
3
4
5
6
7
8
9
10
11
12

and a VL ...
then use a rel to the calc
Apologies to who-ever/where-ever this came from a month or more ago
(from the web), but very useful little method


Chris Brown
University of Adelaide

I am on FM6...so the above method would not work, correct?

So I would create a script for each month and that is all that would be
in the script? If this is a stupid question, I apologize. I've kinda
been thrown into this.

I understand you didn't solve yet your problem.
I offered you (privately) to do it for you.
Do you still need help ?
I could send you an example, but you have to wish it.
(By the way there is nothing hard to do in it ...)
Remi-Noel

"jerthebear" <jerthebear (AT) gmail (DOT) com> a écrit dans le message de news:
1130849900.280272.24930 (AT) z14g200...oglegroups.com...

jerthebear wrote on (11/2/2005):

You could do it that way, or you could do a single script with a custom dialog to ask what month is desired.

Matt