Passing date before record selection

[twes3]

Here's my problem. I have two databases, FISCALDATE & INVOICEDATE. In my FISCALDATE file, i have two fields (begdate & enddate). In my INVOICEDATE file, I have one field (invoice date). I need all records from the INVOICEDATE file that fall within the begdate and enddate of the FISCALDATE file. Both dates field are the same (8 numeric). I need to do this before the report process to get the correct records. Linking the files together doesn't do the trick. Any suggestion?

Thanks in advance.

 

[synapsevampire]

Please post your software, version, and the database being used.

You might create a Command object query in which you CAN join the tables correctly, but I won't waste anymore time until you post technical information.

-k

 

[Madawc]

In your record selection, try

INVOICEDATE.date in [FISCALDATE.begdate to FISCALDATE.enddate]

That ought to work, whatever your Crystal version. (Though you should give it, 8 or 8.5 or 9 or whatever).

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10