Report problem!

[GirishBreakTheRules]

hey buddies,

am generating a report containing fields from various tables which ive selected from a query in wizard view. First of all i want the user to input 2 dates from a message box..and then the report displays the records for the period!.

how can i approach this problem??

many thanx

regards

Girish

 

[lark_tilly]

Do you need the message box?
Can the user just enter the dates in text boxes on the form?
If so, then the criteria for the date fields in your query can reference the text boxes on your form. For example: Forms!myform!txtbox1

 

[GirishBreakTheRules]

hey thanx 4 the reply,

well actually the message boxes arent important as such..i just wana give the user a way to enter dates..thats all...sme1 told me that u can fix the problem using parametrised query. do i need to include the dates in the Criteria option in the query design??

 

[GaryPanic]

ok on a form lets call it xxxxx
have 2 unbound fields set to date format I'll assume uk dates dd/mm/yyyy
the first one call it from and the second to

now in your critia on your qry have between forms!xxxxx!from and forms!xxxxx!to

that should do it
basically this is how it works the qry starts but then asks for date -- ah . it goes I need to look in a form . and its name is xxxxx and the excat location is called from (and then to)

that should do it

regards

 

[BarryMK]

Search Access help on criteria and on expressions, you'll find examples of the syntax for all sorts of stuff