Faster to use "Group" or "First"?

[Jim Pockmire]

I have a query that groups/totals that is linked to another table at the
"group" level. When bringing in fields from the linked table, I can either
specify "Group" or "First" (It doesn't affect the value). Which way will run
faster?

 

[Jeff Boyce]

Jim

Have you tried both?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Van T. Dinh]

In my experience, "Group By" seems to be faster than "First" contrary to my
thought that since "First" only picks the first value so it should be
faster.

Since the QBE defaults to "Group By", I usually leave it as "Group By"
unless I need another Total function, anyway.