Regarding dates

[cnuhima]

Hi,

I have a small doubt regarding the reports..

I my table i have a date field..

In the form i give the list of years and month..

when the user selects the particular month and year..The respective details must be printed in the reports..

how to write a query for this type of report..

Please help me..

With Regards,
Himabindu.

 

[FoFa]

Where year(tabledate) = FormYear AND month(tabledate) = FormMonth

Basically. Of course the FormMonth and FormYear must be numeric values like 2009 and 03 to match unless you go through other gyrations to match them.