Custom Report Design

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report based on qryFixedFootnotes. The columns within the query are
Footnote ID, Footnote, Page Name, Print Order. I'm trying to design the
report where certain footnotes must appear in certain locations base on the
Page Name and the Order it should print on the page.

I was thinking that I could drop multiple text boxes on the report and code
them to look up the data from the qryFixedFootnotes. I wanted to use the
text boxes so I could move them to the correct position on the page because I
will also need to add static data by way of labels throughout the page.

I entered the following code into the first text box on the report:
=IIf([Print Order]=1,[footnote])

This worked and the footnote was displayed, but when I added a second text
box coded as =IIf([Print Order]=2,[footnote]) nothing happened.

Does anyone know why it won't pull in this footnote designated to print 2nd?
Is there a better approach to what I'm trying to do?
 
I guess I'm not sure what the 3rd arguement should be. Can you provide an
example? I'm assuming it wouldn't be a "fail" arguement since the first
arguement will always be true since I am designating the print order for each
note.

Duane Hookom said:
IIf() should include 3 arguments. Your usage has only 2.

--
Duane Hookom
MS Access MVP


msb said:
I have a report based on qryFixedFootnotes. The columns within the query
are
Footnote ID, Footnote, Page Name, Print Order. I'm trying to design the
report where certain footnotes must appear in certain locations base on
the
Page Name and the Order it should print on the page.

I was thinking that I could drop multiple text boxes on the report and
code
them to look up the data from the qryFixedFootnotes. I wanted to use the
text boxes so I could move them to the correct position on the page
because I
will also need to add static data by way of labels throughout the page.

I entered the following code into the first text box on the report:
=IIf([Print Order]=1,[footnote])

This worked and the footnote was displayed, but when I added a second text
box coded as =IIf([Print Order]=2,[footnote]) nothing happened.

Does anyone know why it won't pull in this footnote designated to print
2nd?
Is there a better approach to what I'm trying to do?
Click to expand...
Click to expand...
 
Back
Top