Subject Re: Passing parameters from form to report
From WJS <warra@nowhere.com>
Date Tue, 09 Feb 2016 10:53:06 +0200
Newsgroups dbase.getting-started

On 2016-02-09 01:05 AM, Bob grimes wrote:
>
> My problem is that I cannot however get it to work with more than one memory variable in one SQL statement. For instance when I want to filter an account statement from the bought ledger for one supplier and with a start date and an end date.
> I can filter a table by typing the following in the command window
>
> Select * from bought_ledger where supplier_id = : supplieridx and date >= : startdate and date <= : end date
>

My way would be:

Select * from bought_ledger where supplier_id = : supplieridx and date
>= : startdate and date <= : end date save to TmpRep (or whatever you
want to call the temp table)

Then use the temp table in the report.

The 'save to <tableName>' saves the temp to the local working folder on
the calling PC. So, on a network this is an advantage.

Wian