Insert into unbound object frame on report a bmp image stored in an ole object field in the db (1 Viewer)

[Pat Hartman]

Domain functions inside queries are very "expensive" Each one causes a totally separate query to run. Therefore, the larger your recordset, the more separate queries get spawned. So, if you have a thousand lines in your recordset, you run 1000 queries.

 

[JohnPapa]

Domain functions inside queries are very "expensive" Each one causes a totally separate query to run. Therefore, the larger your recordset, the more separate queries get spawned. So, if you have a thousand lines in your recordset, you run 1000 queries.

Noted.
In my application, there is no noticeable effect. The independence of the Dlookup simplifies programming and maintenance.

 

[Pat Hartman]

As long as your recordset remains small, you won't have a problem. In the real world, a left join isn't any more complicated and has no negative effects but as long as you're happy...............