Range in Report

J

Jw

hi, everyone

i want to set the function for user to able print the report based on the
invoice date (e.g 1-7-2004 to 31-7-2004)

how to create it.

any help or information is very appreciated

thanks

jimmy
 
S

Steve Schapel

Jimmy,

There are a few possible approaches to this. One is to put two unbound
textboxes on a form which will be open at the time that the report is
printed, and have the user enter the date range into these boxes. Let's
say the textboxes are called DateFrom and DateTo. Then, in the query
that the report is based on, in the criteria of the Invoice Date field,
put the equivalent of...
Between [Forms]![NameOfForm]![DateFrom] And [Forms]![NameOfForm]![DateTo]
 
J

Jw

hi, steve

thank for your email

i will try

thanks
jimmy

Steve Schapel said:
Jimmy,

There are a few possible approaches to this. One is to put two unbound
textboxes on a form which will be open at the time that the report is
printed, and have the user enter the date range into these boxes. Let's
say the textboxes are called DateFrom and DateTo. Then, in the query
that the report is based on, in the criteria of the Invoice Date field,
put the equivalent of...
Between [Forms]![NameOfForm]![DateFrom] And [Forms]![NameOfForm]![DateTo]

--
Steve Schapel, Microsoft Access MVP

hi, everyone

i want to set the function for user to able print the report based on the
invoice date (e.g 1-7-2004 to 31-7-2004)

how to create it.

any help or information is very appreciated

thanks

jimmy
Click to expand...
Click to expand...
 
Top