Access 2000 creating report HELP!!!!

  User-30F06F40-507F-43E0-B3DB65A87B01C9A1 15:44 02 Mar 2005
Locked

Adding a new item to a report/form that was not in the original field list

  Fellsider 15:51 02 Mar 2005

Can you give a few more clues?

I have an existing report and have been asked to add a new field to the database which is to appear on the report, I am unable to add this new field as it doesn't appear in the field list which was created when I first designed the report. Is there anyway of adding this new field without having to re-do the whole report again?? I can add the field using the expression builder, although when in the preview screen of the report it only displays #Name? and not the required data.

  recap 16:57 02 Mar 2005

I think you would have to add the field from the table or query that the report is generated from.

  Fellsider 10:19 03 Mar 2005

If you go to help and select 'Add a field in design view'. Follow the instructions there and then re-run the report it should (?) be OK

Suggest you copy the original before you start in case it all goes pear-shaped.

Recap,

Could you please expand please????

  Fellsider 10:44 03 Mar 2005

Load Access

click on Help
select top item:- Microsoft Access Help F1

A little box opens up,
in the white box type 'add field' and select search
in the next box select 3rd item 'Add a field in design view'
A secondary window will open at the right of the screen, follow the instructions then re-run the report.

I haven't actually tried this but the method seems OK

Thanks all for your help it worked

Cheers

BJY

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

Inside the iMac Pro - Apple's most powerful Mac yet

iMac Pro release date, UK price & specs

Comment nettoyer Windows et optimiser son PC gratuitement ?