User Defined Functions

[Jake]

In access you can select a function. E.g. Now(). Can you created user
defined functions that return recordsets and select them like the Now()
function?

 

[bcap]

Why don't you just tell us what it is you are trying to achieve in
functional terms? Clearly you have a bee in your bonnet about something,
you are more likely to get help if you tell us what it is.

 

[Bob Barrows [MVP]]

In access you can select a function. E.g. Now(). Can you created
user defined functions that return recordsets and select them like
the Now() function?

Err .. Now() does not return a recordset: it returns a value. The SELECT
statement is what returns a recordset.
Of course you can create a udf that returns a recordset. However, you will
not be able to use that function in a select statement. The udf will need to
return a value (like the Now() function does) in order for you to use it in
a select statement.