Field order in view using Access GUI kerpet67[ at ]gmail.com 28.09.2006 00:51:55 When I create a view in Access, it seems to choose to order the fields differently than from top to bottom in the view. example Field1 Field2 Field3 Field4 When displayed it comes out like Field2 Field1 Field3 Field4 This may not seem important but from an extract to excel point of view, it is. Curiously though, when you create the same view in Enterprise Manager it formats correctly. Any Ideas? Using SQL Server 2000 SP3, Office 2003 professional Thanks Peter K