Re: SQL Average Function to create a central point

Well I would like to know the SQL statement in whole. which is
(LAT1+LAT2)/2 and (LON1+LON2)/2 Thats my center point average for both.

SELECT
Sum((dbo_Tickets.WorkLatitude+dbo_Tickets.WorkSecondaryLatitude)/2) AS
AvgLat,Sum((dbo_Tickets.WorkLongitude+dbo_Tickets.WorkSecondaryLongitude)/2)
AS AvgLon
FROM dbo_Tickets
WHERE (((dbo_Tickets.Ticket_Number)="05110716012291"))

This I think works.