Order of fields in query design view 2

[merlynsdad]

I have a query with Group By, Sum, Expression and Count fields. I understand the Group By fields need to be at the front, but is there any specific order I should put the remaining types of fields?

If the square peg won't fit in the round hole, sand off the corners.

 

[dhookom]

I don't believe there is any required order for the display of the columns. Have you tried moving them around?

Duane
Hook'D on Access
MS Access MVP

 

[PHV]

I understand the Group By fields need to be at the front
???
Why do you mean that ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[merlynsdad]

I was always told to put the Group By fields up front, but apparently that's isn't necessary. Thanks.

If the square peg won't fit in the round hole, sand off the corners.

 

[dhookom]

I typically place them on the left but it's just so I am less confused later. It's nice to have standards.

Duane
Hook'D on Access
MS Access MVP