hello!

i haven't searched the forums yet because i don't what to type in the search box exactly what i need to display...
i'm using win 7 & access/office 2007.
i made this db wherein all the staff in our office is listed - using ms office 2003 at the time... & i made this query to display all the birthday celebrants per month, so i type only the month in a parameter box, (ex., i type in the word "jan") & the db will display all the employees born under january - regardless of the year... this is the formula i used in access 2003;

in the field: format([dob],"mmm")

in the criteria:[month: (jan, feb >> dec)]

this worked fine when i was using office 2003, but when i copied my db file on my laptop w/ office 07 system, the error box displayed; "Undefined function 'Format' in expression." :(
then when i opened this query i find that access adds the "expr1:" before my expression.... but when i run the query again, the same error occurs.... :confused:
any help would be highly appreciated, maybe if my problem is already solved somewhere in the forums, kindly pls reply the link to me...

many, many thanx in advance!
:)

you have a "missing reference" search for that and find the cause, then fix it.

Edit: Welcome to AWF

you have a "missing reference" search for that and find the cause, then fix it.

Edit: Welcome to AWF


hello sir. thanx for the welcome.
so how do i find the cause & fixing it?? i'm kinda a newbie in office 2007, my apologies... :(

perhaps this will help:
http://www.btabdevelopment.com/main/QuickTutorials/Howtocheckformissingreferences/tabid/71/Default.aspx

search for it, there is a search function on most forums... alternatively use GOOGLE.

Search for missing reference, or follow the link that bob gave

many2x thanx guys! :D bob's post solved my problem! i just left the 4 topmost checked, the rest i unchecked! & it worked like a charm! :eek:
my thank you's! good job! :o