[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Selecting a range of data



Hello

I need to run a report were a user (non SQR person) can define what data
they want to look at.  Currently the report that I trying to write could
have columns such as account number, balance and date opened in it.  The
user might want to look at all the data that has a 'date opened' date
between 23 November 2000 to the 3 December 2000.  The user of the report
might want to look at various different date ranges, therefore hard coding
any ranges into the SQR is not the solution.

I have tried using ASK and/or INPUT.  I can select data for one date but I
can't select a range of data.

I hope I have made this clear

Thanks

Adam