Adding a Field to a pre-existing Report

L

Lisa

Currently run a 'report' for Delivery Schedules. Pulls all customer info.
except for Postal Code which I now need to add to the report. How do I have
Postal Codes pulled into the report? Pulls everything needed but management
now wants postal codes and I'm not sure how to add that field to the report.

Thanks!!
 
G

Golfinray

Put the postal codes into the table or query the form is based on. Now when
you go to the form, check field names (on menu bar) and add that field to
your form.
 
J

Jerry Whittle

First make a backup of the entire database just in case something goes wrong.

Then open the report in design view.

Go to File, Save As and save the report with a slightly different name like
WithZip at the end. That way you can readily go back to the original report.

Next go to View, Field List. A little window should pop up with all the
fields that can be readily added to the report. If you've lead a good, clean
life, Postal Codes should be there. If so skip the next paragraph.

If not, please detail here all things you did that wasn't part of a good,
clean life. ;-) No scratch that. You need to find the query that is
populating the report and add Postal Code to it. While in the report's design
view, go to View, Properties then go to the Data tab. The record source
should be the name of the query. If instead it says something like
"Select...From" then post back what all it says. Close the report and save
all changes. Open the query from above and add the Postal Code field. Go back
to the report and open the Field List.

Once you find the Postal Code field in the Field List, drag and drop it on
the report in the proper place. Not knowing what your report looks like, I
really don't know about how you will have to move labels and existing fields
around.

Run the report. If it works AND you are using the newer version of the
report, you may need to modify any buttons or switchboards that run the
report.
 
L

Lisa

Thanks Jerry! Think that's exactly what I'm looking for. Only have 'read
access' rights to the data base at the moment, but I think once I have write
access (network restrictions), I'll be able to make the changes the way
you've indicated. Field is there....just need to 'pick' it and add it to the
report.

Please detail here all the things you did that wasn't part of a good clean
life?! Funny guy! Can I plead the 5th? How about not answer on the grounds
I may incriminate myself? lol

Thanks for your help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top