mud2
03-31-2005, 10:11 AM
How (can) I
1. Use a user-written function as part of the criteria in a select query? I.E,
The function might return the value of a variable.
2. Obtain the data from such a query...or at least finding out if the query found a matching field...without viewing the query
I hack around this by using a FORM based on the query. I can test a field in the form for NULL or "". But Cannot use a variable in the query's criterion field.
1. Use a user-written function as part of the criteria in a select query? I.E,
The function might return the value of a variable.
2. Obtain the data from such a query...or at least finding out if the query found a matching field...without viewing the query
I hack around this by using a FORM based on the query. I can test a field in the form for NULL or "". But Cannot use a variable in the query's criterion field.