Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2007

    Unanswered: Stupid question - regarding reports

    Hi all,

    I apologize in advance, I'm relatively new to access and have not done many reports.

    my question:

    How do I add another field to my "field list"?, I have already used the wizard to select most of the fields that i need. But i forgot one field and now i dont know how to get it.

    Thanks in advance.

    Also, I'd prefer not to post unnecessarily- so if you know any good websites for me to check out- please let me know.

  2. #2
    Join Date
    Jan 2007
    California, USA
    Not a stupid question! Hey, if you don't know, you just don't know, but that does NOT make you stupid! Now, if you had been using Access for 10 years and did not know this, then I could at least say you were in the wrong line of work.
    OK, here is the answer. I don't know of any wizard to help you change a report. But, if you open the report in design view, then using the menus, use menu View, option Field List, you will find a list of all the fields you can use on your report. If the field you want is there, use it. If it is not there, then you should have a query as the Record Source for this report. Open the Properties window for the report, click on the Data tab, and the click the elipse button "..." on the far right hand side of the Record Source property. If the button is not visible, click on the Record Source property line and it will become visible. After clicking the button, you will be presented with the Query Design Grid. There you can pick the field you need from the table shown in the top of this Query Design Grid and drag it into the bottom portion. Now you can go back to the report and use this newly selected field.
    Hope this helps,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts