design view option under total

[Dan]

im doing a query and in design view i have bank name as
one of the fields. the section called total you can
choose group by, sum, count, first, etc. what does
first mean?

 

[Duane Hookom]

First generally has no real meaning. If you base record source has an order,
it might show the first value found in the source table/query. You are best
off avoiding its use.