User Defined Functions

  • Thread starter Thread starter Jake
  • Start date Start date
J

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?
 
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.
 
Jake said:
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?
Click to expand...

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.
 
Back
Top