How to add a blank Field to recordset 1

[PeterWallace]

I want to ( and can do ) select fields from a table and load them into a MSFFlexgrid
but I need an Extra column in the Grid where User can enter data

e.g select Given , Surname from DenamesTable ... and on the grid I want another column called (e.g) Position

I can call a field of same type as required ( sting , long etc)
e.g
Select Given, Surname , Town as Pos ....
then insert spaces into grid col Pos

this seems like extra work ( 4 letter word) to me

is there any way I can get the Sql Statement to provide the blank column for me
e.g

Select Given, Surname , Newfield as Pos

Thank you for any advice
Peter

 

[PHV]

Something like this ?
SELECT Given, Surname , ' ' AS Position FROM DenamesTable

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PeterWallace]

Thank You PVH

That does the job very nicely

I knew it as possible and simple .. ( exactly the sort of thing that gives me trouble )


I had no success Searching Tek-Tips and/or Internet to find out how to do this ... every search I did ended up with how to add a Field to a Table ( Something I already knew how to do )


Thanking You

Peter