where do i put this data string

[wheels27]

where does this data go or do i build it in expression builder.

Select FieldName, Sum(FieldName) as SumOfFieldName, Avg(FieldName) as AvgOfFieldName
FROM TblName

 

[BanditWk]

Where are you trying to use it? Roy McCafferty
aka BanditWk

Las Vegas, NV
roy@cccamerica.org
RLMBandit@aol.com (private)

"No need to send gifts, just send a smile."

 

[wheels27]

in a query, should it go in the sql screen or some where in the query design screen?

 

[jebry]

Hi!

The code you posted would go in the SQL screen, adjusted to have actual field and table names.

hth
Jeff Bridgham
bridgham@purdue.edu