Footnote in Access Report

Posted on 2006-04-13
Last Modified: 2013-11-28
I need to have three labels show a little 1, 2, and 3. Like a footnote function

Does anyone know how to do this??
Question by:smoschkau
    LVL 10

    Expert Comment

    You could put it in the report's footer.  Not sure exactally what you are wanting to do though.  Are they always going to be there or are there times you may have only 1 footnote?


    Author Comment

    It is a one page report- that has 3 data sources. At the end of each elment name I would like to note that it come from either Data source 1, 2 or 3. That way it will save space.

    That explains it a little better, I think?
    LVL 10

    Expert Comment

    You would have to store your data sources in a table and have a way that shows what data source each record is being used.

    You could have something like

    Dogs have four legs (1)

    and at the bottom of your report in the footer put

    (1) - Webster Dictionary

    If the 3 sources are always used, you could type those sources on the footer of your report in a label.

    LVL 30

    Expert Comment

    Table: data_sources_codes
    ds_id      ds_name
    1      data source 1
    2      data source 2
    3      data source 3

    Table: data_sources_trx
    ds_id      item
    1      item 1
    1      item 4
    1      item 5
    2      item 2
    2      item 6
    2      item 7
    3      item 3

    Report: data_sources_codes
    Recordsource: data_sources_codes

    Report: data_sources_trx
    recordsource: data_sources_trx

    In footer, insert subreport   data_sources_codes
    not linked to main report (clear link fields)

    Result of example:
    item      ds_id            
    item 1      1            
    item 2      2            
    item 3      3            
    item 4      1            
    item 5      1            
    item 6      2            
    item 7      2      

    Page footer----------------------------
    ds_id      ds_name
    1      data source 1
    2      data source 2
    3      data source 3

    Good luck!
    LVL 58

    Accepted Solution


    Is this a formatting issue? You just need the superscipt versions of 123?
    °¹²³ are respectively Chr(186), Chr(185), Chr(178), Chr(179)

    If you need higher numbers, these are only Unicode:
    ⁴⁹ are ChrW(8308) - ChrW(8313), or ChrW(&h2074) - ChrW(&h2079)

    You can add these characters using Window's character map or these expressions, and for the first four with Alt+[Numpad]0<number>. For example, you can have a label with: ² source .......

    If you need help on how to add the superscript number to your data, we will need to know how you combine the three tables or data sources.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now