design view option under total

  • Thread starter Thread starter Dan
  • Start date Start date
D

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?
 
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.
 
You must log in or register to reply here.

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

Group By Desing View 4
Function of colon between table names when query in design view 4
Excel VBA - counting cells by colors and names to it in two different rows. 0
Counting expression doesn't work when sorted by count - Access 200 5
Query Sum return incorrect total. 4
Crosstab query error 1
Help with Date Query and Report 4
Nested SQL Statements causing slowness and errors 7

Back
Top