Does anyone know how i could Filter a report?

[Danielgraham]

I am using Visual Basic 6 and i have a date range i would like to filter on a report. so a form comes up to select two dates (Start and End) then it'll display the data in between those dates. Then i press ok and it will open the report. I know how to do it in access but not in VB.
I appreciate any help given. thanks

 

[johnwm]

You didn't say yet what sort of report you were going to use, what sort of database you are querying and what connection method you're using. Read faq222-2244 to get the best from the forum, both as a question asker and as an answerer.

For this you'll probably use the Between keyword in the SQL you use to get your recordset. There was a recent example of this in the forum and a quick search will find it for you.


________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[Danielgraham]

I using Good old MS Access database with visual basic 6 reports.


Cheers

Daniel