I have a program that uses an Access database and the report designer built into VB 6.0.

Now for the problem. I need to do a date range search using input from txtBeginDate (beginning date) and txtEndDate (ending date) text boxes. I want the report to show only the dates that fall between the beginning and ending dates that were selected by the user in the previous text boxes. So how do I do it ? Do I do an SQL Query ? How do I get only the desired information to print out to the report?

Oh... my client does not want to use a full blown Crystal Report. (Don't want to have to buy Crystal....in other words)

Can anyone help me out?

Thanks