Left Function not working 2

[fockewulf190]

Hello.... I'm trying to extract the first letter of a Middle Name field for use on a report. In a query I set the field to MiddleName: Left([Mname],1)

Then on the report based on the query created above I created a text field and set it's control source to MiddleName

This was working before but for some reason doesn't work on this computer. I'm using Access 2000 on Windows XP operating system.

Thanks in advance.

 

[SteveR77]

What do you get for the value of MiddleName from the query?

Is the value showing up there properly and have you

attemtped to repair and compact the database?

HTH,

Steve

 

[fockewulf190]

Thanks for replying so quickly Steve.

I get an error message:

Function is not available in expressions in query expression 'Left([Mname],1)

I have tried repairing and compacting and Access says the operation completed successfully.

Thanks

 

[JeremyNYC]

Sounds like a references issue. Ctrl-G and then tools | References. If there's one that's missing, write down the name and find it in the list (choose the most recent version available if there's more than one).

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[dhookom]

JeremyNYC gets a star.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[fockewulf190]

Alrighty... thanks Jeremy... you put me on to the right path. I actually had to uncheck the missing References on the list because it was causing some sort of conflict. I appreciate the assistance.

Thanks again

 

[fockewulf190]

Jeremy, gave you a star thanks again!!