Share via

Adding a field in Access 2003

Anonymous
2017-02-17T03:01:53+00:00

I need to add a field in an existing database.     I went to Table Design View and added the field, that went OK.    I then went to the Form, Design View, and brought down the Field List and dragged the new field onto the Form, and this went OK.

I then went to the Report and brought down the Field List - and the new field did not appear.      What have I done wrong?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
2017-02-17T03:42:38+00:00

Presumably the report is based on a query with defined fields, rather than *, so the new field would not be listed. Add the field to the RecordSource and you'll be able to add it to the report.

Was this answer helpful?

0 comments

9 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2017-02-20T03:06:24+00:00

    If you are working in SQL view, you could conceivably add the new field there:

    Change this:

    Awards], herddata_6.[Registered No], herddata_6.[Stud], herddata_6.[Name], herddata_6.[Classification (senior)], herddata_6.[Milk Award], herddata_6.[Show Awards]

    FROM (((((herddata LEFT JOIN herddata AS herddata_1 ON herddata.[Sire's No] = herddata_1.[Registered No]) LEFT JOIN

    to:

    Awards], herddata_6.[Registered No], herddata_6.[Stud], herddata_6.[Name], herddata_6.[Classification (senior)], herddata_6.[Milk Award], herddata_6.[Show Awards], herddata.Microchip

    FROM (((((herddata LEFT JOIN herddata AS herddata_1 ON herddata.[Sire's No] = herddata_1.[Registered No]) LEFT JOIN

    Note my spelling of Microchip, and my guess that you have this field in the herddata table. Adjust as needed.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
    2017-02-18T12:19:34+00:00

    Design the report. Open the Properties window. Find the RecordSource property. Click the ... button next to it. You are now in the query designer where you can add a field from a table object at the top to the grid at the bottom.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2017-02-18T00:48:48+00:00

    Thank you, Tom.    

    The database I am amending was not written by me, it was written by a friend who is now dead, so I am not able to ask him.      I am by no means an expert, so I am not sure what your reply means - I shall have to go to my "Access" manual and see if I can make sense of it.

    It is really nice of you to reply to my problem.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2017-02-17T08:31:00+00:00

    Thank you Tom.      I am not sure I quite understand your reply - I did not write the original database, so I shall have to give it some thought.     How do I add the field to the RecordSource?     Sorry to seem dense but I'm not an expert.

    Thanks,

    Dorothy.

    Was this answer helpful?

    0 comments