Access2007 query - is it me?

[sportsguy]

Vistax64 OS, 8 gigs ram (fast)
MS Access 2007 (just converted)

trying to insert a column in a long query. . . highlight field, go to ribbon under query setup, and the insert row is activated, but the insert column is NOT activated. . .

how do i insert a column? or is it me?

thanks

sportguy

 

[lemo]

could be you. i am in access 2007 design query view, and i can see 'insert columns' and it's not grayed out..

you don't need to use it though, in the design view you can just drag the variables of interest from tables to the variables area below..

l

 

[sportsguy]

kind of strange that there are three items in the query setup box that I can't make to be active, insert columns, delete columns, and delete rows.

and no, I don't want to use workarounds for habits which I deem efficient, just because the software is buggy. . .

sportsguy

 

[sportsguy]

Well, it wasn't me, the Office 2007 updates solved the issues. . . although Vista x64 business is not 100% stable yet, it is fast

sportsguy