Your IIF() expression tells Access to look for EXACTLY "Voluntary" in the
[Type] field. If you meant "Voluntary" SOMEWHERE IN the [Type] field, you'd
need to use something more like:
I would like to use an IIF statement to look for the text in field [Type]
and
if it is not Voluntary, to show Employer on the report.
I have tried IIF([Type] Not Like "Voluntary","Employer","Voluntary") and
all
I get is Employer listed on the report. It changes those that are
voluntary
to employer.
RE: Duplicated data in a report ...tblEmployerJobs...tblStudentJobs... I have re-read my earlier post asking for assistance with a report.... selected it as a first choice.... (microsoft.public.access.reports)
Re: Report Page Event ... I wasn't able to have any event triggered paging backwards through the report... The page property also updates only on forward paging. ... code given in Access help under 'Page Property', ... When I page backwards, the caption doesn't ... (microsoft.public.access.reports)
Re: Quartile function ... its included in access help without mentioning that it ... used your code to display median, Q1 and Q3 in most of my ... The only trouble I have is when I have a report that does ... >or whatever you want - for the first quartile boundary... (microsoft.public.access.modulesdaovba)
Re: Advice on Data Protection Act needed please. ... In short my wife had a fall at work over ... provided by the employer for moving a heavy box - such as a trolley. ... Does she work for the Benefits Agency?... questions asked but a copy of their consultants report... (uk.legal)
Re: Advice on Data Protection Act needed please. ... accident book her employer was aware of her claiming against them. ... The report was completed on behalf of the company so they can supply ... Why wouldn't you want the benefits agency seeing it ... They are objecting to the company sending past history to try to ... (uk.legal)
