Functions

[gelabelle]

Hi

How can I take the value from a field in a table and make it a Function

Example: I have a table named "Percentagetbl". Inside the table I have a numeric field name "Underground"
I wish to create a Function which will contain the value of the field (eg. .2)

Once the Function is created I can then use that Fundtion name in any of my queries.

[June7]

A field cannot be 'made into a function' - a function can pull data from a table. If table has multiple records, there must be some criteria provided that will identify which record. Which record should this value come from? What is the determining circumstances and criteria?

[Micron]

Your post makes more sense to me if I think in terms of built-in functions or custom expressions - otherwise, not much.
If your table only has one record in it but the value of 'Underground' can change, you can use DLookup to retrieve it. If you want to use this in a query as a custom function, you'd write something like

Function GetUnderground() as Integer  [or Long, or String, or whatever]
    GetUnderground = DLookup("Percentagetbl","Underground")
End Function

and call it from your query. If there is more than one record in the table, you cannot do this as written. But if you're looking for records to be returned by other queries and your data is that simple, why not just create a query that returns 2 (i.e. the Underground value) and link that field to other tables in your queries?