Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calling a function in an update query

Status
Not open for further replies.

Hattrick16

Technical User
May 6, 2005
17
0
0
US
I create functions for a complex calculations in my DB. I call the function in an update query to place the result in a table. When desiding the update query I would get all the variables to feed into the funtion like the following example.

EXAMPLE:
Sample («Test1», «Test2», «Test3», «Test4», «Test5»)


Since updating to Acess 2007 I only get:
Sample()

Is there a setting that is not set correctly or do I need to do something different.

Nick
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top