Need a bit of help

[Guest]

I need some help figuring this out, I have a form where it puts out today's
date and then the user selects a dropdown list of a sales reps and then
selects a check box as to whether or not that sales rep is In or Not In
(which i have diplayed as a value in the table either 1 or 0, 0 as In, 1 as
Not In), then the user types in all other information about the sales rep
sales for that day.
For the report i have it list all the information about that salesreps sales
for the week for example, but now i want it to list all the dates he was not
in for that week, i tried adding a sub report to my report, to show all the
dates that that sales rep was not in, i got it to work but it would not grow
to show all the dates that sales rep was not in, it got cut off. I even tried
selecting the can grow option in the properties for that subreport to yes,
but it would'nt grow larger to show more dates than what was there. Plus i
don't want a large space between the dates not in and all the other
information about that sales reps sales for the week.
Anyone have any ideas?

Thanks,

Steve K.

 

[Guest]

Ok, never mind the question below, i got it to work using a IIf expression,
but now i have another question.
This is what i have in the text box's control source listed in the detail
section of the report....
=IIf([NI]=1,[Today'sDate],"")
but now instead of listing all the dates in a nice condensed list of the
dates that the sales rep was in, it shows a blank space. Is there a way to
make it not show the blank parts that the salesrep was in, but still condense
it down to a smaller list?

 

[Steve Schapel]

Steve,

I think it would be better to base your subreport on a query that just
selects from your table the dates where NI=1.

By the way, as an aside, I would recommend against using a ' as part of
the name of a field or control.