Subject: Use of Folder in Expression Builder

  • Thread starter Thread starter Regi
  • Start date Start date
R

Regi

Hi,

When I open Expression Builder in a query and then open the Functions folder
an addittional folder appears with the name of my database in it. In the
Northwinds Sample Database I saw that this folder can hold expressions. I
just can't fiqure out how to use it. I was wondering if I could put
frequently used functions like Sum and Left in there so I don't have to
scroll throught the whole funtions list.

Thanks
 
No, this folder lists the functions that have been created in VBA modules.

In theory, you could write a "wrapper" function to call the standard built-in
VBA functions, but that would probably be a lot more trouble than the benefit
received.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 
Thanks John.

John Spencer said:
No, this folder lists the functions that have been created in VBA modules.

In theory, you could write a "wrapper" function to call the standard built-in
VBA functions, but that would probably be a lot more trouble than the benefit
received.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
Click to expand...
 
Back
Top