Hi, I am recieving an undefined function in 'Mid' expression error when running a query, I have used this in similar circumstances in other DB's but it just won't work here.

store: Mid([tbl_store_data].[profitctr],2,4)

Any suggestions?

Have you checked to see if you have any reference (http://www.accessmvp.com/djsteele/AccessReferenceErrors.html) problems?

I have checked that all my references are the same for another database where the Mid function does work, however I am unsure of the specific reference that Mid would be refering to

I have checked that all my references are the same for another database where the Mid function does work, however I am unsure of the specific reference that Mid would be refering to

It deals with the MSCOMCTL.OCX file and so you should be able to fix it by just going to Tools > References and in the dialog click the browse button and browse to that file (if in XP it would be under C:\Windows\System32 folder). Use Windows search if you can't find it.

It is also possible that you could have a *bogus* MISSING reference that simply needs to be deleted. Check the link I posted.

Thanks for the assistance, I added the referrence boblarson mentioned, didn't help, I will go through the link you provided RG. Let you know how I go. FM.

Thanks, problem rectified, missing Activex component