Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Form values use in an report

Status
Not open for further replies.

NSits

Programmer
Apr 7, 2003
1
NL
HI, I've a little question. I have a form with 2 textboxes on it. These are used to fill in a date. Now here is the problem. I want to generate a report that contains all of the records between the 2 date's in the textboxes.
I know how it is done in SQL, but I've got no idea how to get the SQL in the report.

Thanx,

Niels
 
You need to open the report by calling the Method 'OpenReport' with the WhereCondition set as appropiate (use thee Help). The report will need to have 'Filter On' set to Yes.

I don't know experienced you are, but if this all seems very difficult, try to work up to this by setting the filter manually in the report itself first to see how it should work

Simon Rouse.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top