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 derfloh 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
Joined
Feb 6, 2006
Messages
1
Location
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