I am doing a small database for my wife's boss in his two person company. I developed the database using Access 2000 and upon moving the mdb file to his computer which has Access 2002, the "format" function in several of my report queries (ex. <b>EndMonth: Format([EndDate],"mmmm yyyy"</b>) no longer works? Any insight into why, and the best way around it?
I need it as the report form that launches the report provides the month to the query in the "criteria" row of the query in the format "mmmm yyyy".
Thanks for your help in advance!
Joe
I need it as the report form that launches the report provides the month to the query in the "criteria" row of the query in the format "mmmm yyyy".
Thanks for your help in advance!
Joe