>Thank you Jim. It works fine with NOFILTER but I think I will use _tally because using NOFILTER can decrease query performance since it creates a temporary table on disk. I just want to have the number of records selected.
If you need the SELECT only for the number of records, use a COUNT (set before a relation between tables). It should be faster.
Vlad
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only