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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Generation

Status
Not open for further replies.

kadar

Programmer
Feb 6, 2006
1
US
Hi I have a form which iputs a from date and to date. I want my report to print all the records which meets the date range.

Like Report Form abc for shipdate >= date1 and shipdate <= date2 Prev

I couldn't use the Thisform.txtship.value to pass to the report.

Could any one help me out in this.

Kadar
 
Use a cursor (with SQL select) as the source for your report. It is the easiest way to manipulate data.
You can also set a filter on your table when printing the report.

HTH,
Weedz (Wietze Veld)
veld4663@exact.nl

They cling emotionally to code and fix development rather than choosing practices based on analytical assesments of what works best.

After the GoldRush - Steve McConnell
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top