Thank you for your post.
Let's assume your three fields are:
Date (a date field)
Value (a number field)
YesNo (a text field)
Pulling down the View menu and select "Find" will allow you to search.
For a range of dates, using the current month, enter into Date: 10/1/2008..10/31/2008
(If you are outside the United States, enter: 1/10/2008..31/10/2008)
Pressing return will find all records where the Date occurs in October, 2008.
At this point, pull down the Records menu and select "Modify Last Find". You will find yourself back in Find mode with the date search still active. Go to the Value field and enter the value (between 1 and 6). Pressing return now displays all records that occur in October, 2008 and also contain the specific value in the Value field.
Pull down the Records menu again and select "Modify Last Find". Along with the other two search criteria, enter a value into the YesNo field. Press return and that will find all records that satisfy all three criteria.
You don't have to search and refind each time. You can enter all the criteria at once. I was doing this to give you a better explanation of how Find works.
If certain records are not showing, make sure the field types are correct. If Date is actually a text field, then FileMaker looks at the data as text. For example, if you are outside the United States, and you had the search above, the following records would appear in the sort:
The following would not appear, because you are searching for 1/10/2008 through 31/10/2008, and the first digit would be out of that range:
Does that make sense?
I hope this helps. If not, please give me a test case that I can try out here. Be sure to include the field names and type.
Just a quick tip - if you are using FileMaker Pro 9, you can quickly search for dates in a specific month by entering just the month and the year as the search criteria. For example, to find all records from September 2008, you would enter Find mode and then type 9/2008 in the date field. Easy :smileyhappy:
Many thanks guys. Problem solved and fingers crossed an easier end of month beckons :robothappy: