expr1001

[melda11]

I want to change the column name after I have run my select query.The column name is currently expr1001.How can I do this??

Thanks

 

[WayneRyan]

Melda,

If you don't want Access supplying the names change the SQL to:

Select Field1 As FieldNumber1,
       Field2 As Whatever,
       Field3 As [Two Words]
From   SomeTable

In the Query grid, just make the field:

FieldNumber1: [Field1]

Wayne