Date Find - Frustrated Mind

[habitude]

I need to find a way to script a "date find"!

My file has over 90000 records of customers and once in a while, a customer "borrows" a car from us, and a "rental" type form is created.

Three date fields are present on the layout:

1. Dateout (which triggers a "Car Out" flag)

2. To Be Returned

3. Returned (clears the flag)

The task is to create some reports these rentals. One showing all cars currently out was simple to build.

However, another report showing ALL cars that were ever loaned out, current and closed!

Out of 90000 customers, only about 300 have EVER borrowed a car, and currently there are only 3 out right now.

So far, my attempts to find just those 300 has bombed, either I get just the current 3, or I get the entire 90000 records.

I'm out of clues, can someone please lend me one?

-)

[cjaeger]

why not make a flag on returned?

or do a simple search:

1rst request: dateout > 1.1.1900

2nd request returned > 1.1.1900

[CobaltSky]

To find all customers that have ever had a car on loan, you might like to search for all records with a value in the 'Dateout' field.

To do that, I suggest that you try the following:

Enter Find Mode [ ]

Insert Calculated Result ["BCA DateLoaned", " "> 0/0/0000" "]

Perform Find [ ]

Go To Layout ["Your report layout"]

That should do the trick for you.