Custom Report Design

M

msb

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?
 
M

msb

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?
 
D

Duane Hookom

I would expect to see something like:
=IIf([Print Order]=1,[footnote], [headnote])


--
Duane Hookom
MS Access MVP


msb said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top