Formula to capture filename in a query.

[Ajit Singh]

Need a formula which can capture filename for me. For example, I have a db saved at "C:\D\location\office\China.accdb". Is there a way to capture "China" in a query?

 

[pr2-eugin]

You can use CurrentProject.Name, to get the file name, then use Left function to get the find the file name.

? Left(CurrentProject.Name, Instr(CurrentProject.Name, ".")-1)

 

[Ajit Singh]

Awesome ..................thank you so much !!!!!!!!!!!!!!