Add data to page footer

[mike]

Hi
I have been asked to add some data to a report that I create from an access
2003 Db. The report contains the exhibitor numbers and names in the local
flower show. The list is used to for the judges to match an exhibitors
number to the exhibitor name. The report prints about 10 pages with
exhibitor number, their name and some other specific details about the
exhibitor.

I have been asked if the footer of each page can contain the range of
exhibitor numbers that it shows so that it makes it easier for the judges to
find a specific exhibitors name based on the number.

For Example: At the bottom of page one the footer would show Exhibitor 600 -
631, Page two footer would show 632 - 663 etc obviously dependant on the
exhibitors numbers listed on that page.

Any ideas will be greatly appreciated.

Regards

Mike

 

[J]

Mike,
Place a text box in the footer.
right click
properties
data
control source : "=([exhibitor number])" without the quotes
This will always be the last records [exhibitor number] on the page

Then place a text field in the header.
delete the label
right click on it
properties
visible = no
(note the name of this field)
Click on the page header
Right click
Properties
Event
on print
Click the "..." to the right
Code builder
Type [your text box name] = [exhibitor number]
this will always be the first records [exhibitor number] on the page

Place one more text field in the footer
right click
properties
data
control source : "=([text field in the header name])" without the quotes

I ran it on one of my reports and it worked. Let me know if you have
questions.

J

 

[mike]

Hi J
Well I have tried and tried and I cannot get this to work! Everytime the
text field in the footer points at the text box in the header it returns the
same result as the text box that is already in the footer.

So I have the footer showing the last record number for that page but I
cannot get the first record number to show in the footer.

Any additional pointers will be appreciated.

Regards
Mike

Mike,
Place a text box in the footer.
right click
properties
data
control source : "=([exhibitor number])" without the quotes
This will always be the last records [exhibitor number] on the page

Then place a text field in the header.
delete the label
right click on it
properties
visible = no
(note the name of this field)
Click on the page header
Right click
Properties
Event
on print
Click the "..." to the right
Code builder
Type [your text box name] = [exhibitor number]
this will always be the first records [exhibitor number] on the page

Place one more text field in the footer
right click
properties
data
control source : "=([text field in the header name])" without the quotes

I ran it on one of my reports and it worked. Let me know if you have
questions.

J

Hi
I have been asked to add some data to a report that I create from an
access
2003 Db. The report contains the exhibitor numbers and names in the
local
flower show. The list is used to for the judges to match an exhibitors
number to the exhibitor name. The report prints about 10 pages with
exhibitor number, their name and some other specific details about the
exhibitor.

I have been asked if the footer of each page can contain the range of
exhibitor numbers that it shows so that it makes it easier for the judges
to
find a specific exhibitors name based on the number.

For Example: At the bottom of page one the footer would show Exhibitor
600 -
631, Page two footer would show 632 - 663 etc obviously dependant on the
exhibitors numbers listed on that page.

Any ideas will be greatly appreciated.

Regards

Mike