IIF Statement in Report -- Anyone want to take a stab?

  • Thread starter Thread starter bw1019
  • Start date Start date
B

bw1019

Guest
I'm having a little problem getting my data in this report to align to the top of the details section. It appears to be from the IIF statements I'm using in the Details section of the report, generating many blank spaces and which I need to get rid of. I've racked my brain and I'm stumped.

Attached is a sample of the database with two examples in a table. All you have to do to view the report is enter the date 2/5/06 as the Start Date in the Form WDC Payroll Audit Form and then you can view the report (WDC Payroll Audit) and see the problem I am having.

Its really got me stumped and any help is greatly appreciated. Or even reposts of people saying there stumped would make me feel a tad better.

THANKS!
View attachment Payroll Audit Help.zip
 
Sorry, I can't, I'm getting an error saying that I'm missing something needed to convert it and that conversion is unsuccessful. Thanks though
 
bw,

I have had a quick look at this from home.

You have come up with an interesting way to create a report!!

Firstly, I don't think that you need to have dateserial at all.
If you want to get an increment to a date just put something like the following...

forms!form!strdate + 1

Your if statement has a true part, but it doesn't have a false part. You must include it or it will output a space.

Change the first field in the detail section to the following and you will see what I mean.

=IIf([_Key_Date_Under_Report]=[Day1],[Trc] & " " & [Tl_Quantity],"bob")

To be honest I think that you are better off doing something like the following:
Create a single input for date in a form.
Include a command button on the form that invokes your report.
Base the report on a query, where the criteria references the forms date input.

HTH,

J.
 

Users who are viewing this thread

Back
Top Bottom