I Have a database that has members and events for these members.

The client need to enter a from date and to date and when they click on search button it needs to show a report of all events for that period.

[ FROM DATE ] [ TO DATE ] [ SEARCH BUTTON ]

Jemermy - Birthday 15/01

Greg - Birthday 19/01

Where do we find the edit text box to put in there... it needs to be a blank field where you see the [ FROM DATE ] section it keeps asking me to enter in a field name or related data. I just want a blank space.

Please help on how to achieve this and also a simple script.

Thanks in advance.

Edited January 19, 201510 yr by Lee Smith
External URLs removed. They made no sense as a reference to this post.

See if this helps Finding ranges of information

Where do we find the edit text box to put in there...

 

Not sure what exactly your question is. If you want to get user (keyboard) input, you must give them a field to type into. In the circumstances, you probably want two Date fields, with the storage set to global. These can be in any table. Then you can use a script along the lines of:

Enter Find Mode []
Set Field [Events::EventDate; SomeTable::gFromDate & ".." & SomeTable::gToDate]
Perform Find []

to find events in the given range.

 

 

Note that this will find only events whose date is in the given range - including the year. It will NOT find all people whose birthday is in the given range, if all you have is their DateOfBirth. That's a different problem altogether.

 

 

---

P.S. Why does your question contain links to another forum's actions?