Find and don't show me??

[soriano]

Hi, again

I try to make a patient list of "x-day", e.g. today is February 11th, the list show me all the patients with appoiment in this date, in this DB (Appointments), I have 4 fields (date, time, time_app & time_in) I have a relantionship with my master DB (Patients), just I want to find the appointment's patients, but, If field time_in Is Valid don't show this patient.

I hope you can read this, please I need help.

Best Regards

Jorgs Soriano

Saludos from MEXICO

[Fitch]

Your script would look like this:

Enter Find Mode[]

Set Field (date, Status(CurrentDate))

Paste Result (time, "=")

Perform Find []

Another option is to use these steps in place of the "Paste Result" line:

New Record/Request

Paste Result (time, ">0")

Omit

I'm not sure where your related file comes in, but since this is the Finding & Searching forum... I won't worry about it.

[soriano]

Hi...

Just a question where is it the "Paste Result" in the script menu I can't see it...

Sorry maybe this question is to silly.

Jorge Soriano

[Chuck]

Look for Insert Calculated Result instead. It changed, I think with version 5.

Chuck