Does the IIf function work differently in queries from the way it works in
reports?

For example, this works in a query:

lastName: IIf([Last]="Smith",Null,([Last]))

(I can hid the last name "Smith" in the lastName field.)

However, I cannot use the same IIf as a control source in a report. It
generates a circular reference error message.

= IIf([Last]="Smith",Null,([Last]))

(If the name is not "Smith", then print it.)

Is this just how IIf works?

Thanks folks. I actually got it working using Domain Sum. Sorry for delayed
reply.

Thanks again!

"Allen Browne" wrote:

So all you need is a row of labels and 4 rows of empty boxes
(plus the pagemumber?), right? If so, you can do what Ken
suggested.

If you need to reduce the space used by the page footer to
just the page number on the other pages, then that's where
it gets tricky. One rule about changing the height of the
page footer section is that it needs to be done in a page
**header** event procedure. Another thing is that you can
not reduce the height of a section so the section's bottom
is above the bottom of the lowest control in the section.
This means that the controls have to be moved up in the
section first (the opposite is true when you move a control
down in the section). A vague outline of the page header
code would be something like:

I would expec the parameters to come from controls on a form. You should be
able to add text boxes to the report near the graph with control sources like:
=Forms!frmParameters!txtStartDate
--
Duane Hookom
Microsoft Access MVP

NOTE: These public News Groups are ending June 1st. Consider asking
questions at http://social.answers.microsoft.com/Forums/en-US/addbuz/threads?

"Alaska1" wrote:

Assuming a max of two words, and exactly one space between first and last word.

Left([Comp Entered By],1) &
MID([Comp Entered By],Instr(1,[Comp Entered By]," ")+1,1)

IF you have more than two words (names) in the field then you have to decide
what you want to do. Oscar de la Renta, Mary Jo Kopechne, Mary Anne Smythe

When I export a report from Access to Excel via DoCmd.OutputTo I get an error
from Excel saying Invalid Sheet Name. What can be causing this and how I do
to keep this error from happening?

What happens if your data is not in alphabetical order but in an order that you want to have this merge field criteria applied? What if you have multiple merges that you would like to perform? Here is my data:

Raw Data is to the left. For sorting purposes, I put "C" data in before "B" but it does not have to be sequential. Keep in mind, the order of the raw data is important and I do not want to change this when I merge the levels afterwards. My merging criteria would something like this where is x is the letter and * is the number:

C1 - C8 merges to C0
C11 - 13 to C1
B1 - B5 to B0
B11 - B16 to C1

C0 and C1 combine to C
B0 and B1 combine to B

Finally both can be merged on the 3rd level to Alpha. How can you program this?

Thanks,
David

Hello,

I am having a problem with a report. I am trying to print out paystubs for
employees over a given time period. I have a start up form in which the user
types in the “StartDate” and the “EndDate” of the pay period which is 2 weeks.
I need to be able to calculate the regular/overtime hours for each week so I
created two queries, “qryPayrollWeek1” and “qryPayrollWeek2”. Each of these
queries contains the same fields:
Operator/DateWorked/HoursWorked/RegularHours(Calculated Field)/OvertimeHours
(Calculated Field). Both of these queries work great. When I type in a
StartDate and EndDate, I get a record for each day for each employee within
the date range with all of the correct information.

Hi,

I have a footer (groupFooter3) that has a bunch of controls in it, and is
about 4cm high. Is it possible to close up the footer to zero height if one
of the key data fields has a null value, but leave it alone if there is a
value? And if so, some quick guidance as to syntax.

Cheers people

Paul

In Access 2003 I have a report based on a crosstab query that displays the
total number of checks deposited by month to different banks for two years
and the difference between the current and previous year each month. I need
to know if there is a way to only display the montly data if there is a row
for both years. We only started tracking the data in April of 2009 so...
The Query data looks like this:
DepYr DepMoNbr BOA JPMC WllsFar DepMo
2009 04 3000 2624 1012 Apr
2009 05 2954 2326 1024 May
2009 06 3004 2459 1063 Jun
2009 07 ~~~ etc. up to May of 2010
2010 04 3583 2789 1193 Apr
2010 05 3548 2753 1127 May

The report looks like:
DepMo DepYr BOA JPMC WllsFar
2010 1234 2345 3456 Detail row
Jan 1234 2345 3456 DepMoNbr footer
2010 ...