adding a field to an recordset

[gary]

How do you add a field to the begining of the recordset.
I need the new field to be the first field.

Thanks

[Larry Linson]

Re: adding a field to an recordset


"gary" <grmman@verizon .net> wrote in message
news:eb1dc71a.0 404061215.7f3dc 325@posting.goo gle.com...[color=blue]
> How do you add a field to the begining of the recordset.
> I need the new field to be the first field.[/color]

To the beginning of a _Recordset_? Recordsets are returned when you read
from code a Table, Query, or SQL Statment, or when you execute a Query or
SQL Statement. "Adding a Field" doesn't make much sense to me, unless it is
a Calculated Field in the Query or SQL Statement.

If you mean a _Table_, open it in design view, highlight the first Field,
and press the Ins key which will move the Fields down the grid and open up
an empty one, into which you can add your definition information.

If I have misunderstood, please clarify.

Larry Linson
Microsoft Access MVP