I have a report that draws on data tables in a vertical market application. One of the fields is a numeric field in which the entries designate the year and the month: 200901 for January, 200902 for February, and so on. I am trying to set up a formula that will pull records for the year that run up through the present month. I have tried things like CStr(tablename.dtfield) <= CStr(Year(CurrentDate())) & CStr(Month(CurrentDate())), but so far no luck. Any suggestions as to proper syntax?
Thank you in advance for your help.
Also, if there s a better forum for this kind of question, please feel free to enlighten me.
Thank you in advance for your help.
Also, if there s a better forum for this kind of question, please feel free to enlighten me.