If I have a field called "Appt Date" and I want to find how many future
appointments there are in the database, how would you do that. I thought....

New Field - Calculation "Appts Outstanding" - If (Appt Date= ? // ; 1 ; 0)

This will not work because it won't allow the entry in the calculation
field.? //

Any suggestions?

Thanks

Looks like my text was translatted ? should be greater than or equal to!

Falcon wrote on (9/27/2005):

What's the If stuff? You don't enter a calculation like that in a find
request.

Find (greater than/equal to symbol) // is all you need.

Described in "Finding numbers, dates, times, and timestamps" in Help.

Matt

--

Sorry not explaining myself here.

I want to create a field that will have a running total of apps due. So I
though that the field would see if the appt was due in the future, if so
give it a value of 1 if not 0

Then display this field!

I was not looking for a search and find!

Falcon

OK.

Try this:

A calculation field:

AppointmentsRemaining = If ( ApptDate => // ; 1 ; 0 )

and

A global AppointmentsCount = Sum ( AppointmentsRemaining )

You might also do it with a relationship between your ApptDate field => a
global field set to Get (CurrentDate), with a field expressing a Count of
records matching that relationship.

Matt

--

Matt I should say I'm using FM 8 and it does not like

If ( Appt Date => // ; 1 ; 0 )

Error message "A number, text constant, field name or "(" is expected here."

In article <znd_e.4239$RW.2175 (AT) fe2 (DOT) news.blueyonder.co.uk>, "Falcon"
<info (AT) getlost (DOT) com> wrote:

I'm not sure about FileMaker 7 or 8, but I don't think you can use //
within a calcuation field or auto enter calculation. Instead you should
be using the Get(CurrentDate) function.
ie.
If ( Appt Date => Get(CurrentDate) ; 1 ; 0 )


The // is a special symbol to obtain today's date, but only when used
in Find mode.



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

I think what you're looking for is to create a global date field
"Date_g" and that needs to be linked to your "Appointment Date" but
link it as
Date_g <= Appointment Date

Then create a calc field that just counts the number of related records.