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
Printable View
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
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
datefield is single field formula should also be single
ex. year & month{tablename.datefield}=year&month(datepicker)
please tell me the exact syntax