custom function not running once per record

S

Sasha Furr

I have a cutom function which has 5 fields as parameters.

It runs tests on the values of the fields and makes
different calculations accordingly.

When I call it in a query, it is not running once per
record, but instead is giving the same results for ALL
records.

The data in the five fields is definitly different from
record to record! Why isn't it 'seeing' the new data?

thanks,
Sasha
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

running total of records in query 1
how to get last records out of 4 records per customer? 17
Use a function in the "Criteria" of a query? 3
Random Function for Selecting Records 6
Sequential Record Use? 3
Highlighting Updated Records 2
Storing calculated query results 2
SQL or maybe a hardware issue for finding lowest Repair order date or mileage 1

Top