date and month formula

[yousufkhan]

In access i am having date field in a table

from vb6 i wanted to call al crystal report giving condition
on date i only want to give month and year to crystal formula while calling a crystal from vb to chech in the table wht is syntex

[brucevde]

Assuming I know what the hell you are talking about

In the Record Selection Formula use

Year({TableName.DateField}) = the Year Parameter And
Month({TableName.DateField}) = the Month Parameter

[yousufkhan]

datefield is single field formula should also be single

ex. year & month{tablename.datefield}=year&month(datepicker)

please tell me the exact syntax