[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Footnote in Access Report

Posted on 2006-04-13
Medium Priority
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

ID: 16446711
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

ID: 16446741
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

ID: 16446829
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 31

Expert Comment

ID: 16448770
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

harfang earned 2000 total points
ID: 16456370

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.


Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

873 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