Hello guyz,

i generated a report based on a simple query that i've buit and all the records are displayed accordingly. But wen i parametrised my query in the Criteria(e.g:Between [startdate] AND [enddate]) of the query that will generate report between 2 dates input by the user the report displays only the Headers but not the records!...i have set the Record Source property to the query name aswell..but yet no positive results!

Can anyone suggest me a possible fix for the problem plzzzz?

Thanx 4 the time

Regards.

Post the SQL.

I'm guessing that you two dates are sitting on a form. If that's the case, then in your query you must reference the form and the text box where the dates are. As an example, in your query you would reference as follows:

Between MyForm!Mycontrol_1 AND MyForm!Mycontrol_2

Gine that a try and see what happens. If it still doesn't work then post back

Maurice

Sorry about my last post....it should read as follows:

Between forms!MyForm!Mycontrol_1 AND forms!MyForm!Mycontrol_2

Maurice

Sorry about my last post....it should read as follows:

Between forms!MyForm!Mycontrol_1 AND forms!MyForm!Mycontrol_2

Maurice

hey buddy thanx 4 replying. It isnt working.lol. i'll make u get the whole picture. i have a subform on a tab which has a textbox(out of several textboxse): date of application, on another tab i have a command button..so wen i click u get 2 prompts to enter 2 dates to get the report....

i used" Between [Reportbegindate]AND[ReportendDate] in the criteria....wen i dnt use the criteria i get the report displayin records but wen i use it i dnt get anyfing apart from report headers!!.

PS: Where must i place the criteria by the ways!


plz help!

Regards

the criteria goes in your query

Hey buddy ,

actually i made a little mistake by puttin the criteria for another field rather than the date field.

Thanx nyways 4 ur help.

regards