Group:  Microsoft Access ยป microsoft.public.access.gettingstarted
Thread: Adding a field to the field list

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Adding a field to the field list
Tarrago 21.07.2006 21:56:01
I created a table and the a report from that table and then was asked to add
another column/field to the table. Now I don't know how to get that field to
show up on the field list so that I can add it to the report. Can anyone
help.

RE: Adding a field to the field list
KARL DEWEY 21.07.2006 22:23:01
You need to open the report in design view and see what the record source is.

If it is directly from the table just close the report after saving the
table and then open the report in design view and it will be there.

If it is a query then open the query in design view and add it to the grid
as an output field. It will automatically appear in your field list.

If it is not from the table directly or a query then you will need to type
it in the record source statement. Just insert the table name and field name
using bractets with a period between the two and separate it from the other
fields with a comma.

"Tarrago" wrote:

[Quoted Text]
> I created a table and the a report from that table and then was asked to add
> another column/field to the table. Now I don't know how to get that field to
> show up on the field list so that I can add it to the report. Can anyone
> help.
>

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net