[AccessD] Report Query

Stephen Bond stephen at bondsoftware.co.nz
Thu Jun 17 04:26:32 CDT 2004


In the query

   IIF(IsNull([Form]![frmReports]![rptPremise]), True,[Form]![frmReports]![rptPremise])

in the Field row of the query, and

   True 

in the Criteria row.

Stephen Bond

> -----Original Message-----
> From: Martin Caro [mailto:mcaro at bigpond.net.au]
> Sent: Thursday, 17 June 2004 7:10 p.m.
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Report Query
> 
> 
> I have a report query that references a form window to pick 
> up a FK value. I want all the records for that value and it 
> works OK when there is a value in the field. 
> 
> [Form]!frmReports]![rptPremise]
> 
> If the field is Null then of course there are no records 
> returned....but I want all records irrespective of the FK 
> value ... perhaps along the lines....
> 
> IIF(IsNull([Form]!frmReports]![rptPremise]),    ?    
> ,[Form]!frmReports]![rptPremise])
> 
> .... is there some syntax or a technique here to return all 
> records if the criteria is Null ? It's hiding from me!!!
> 
> 
> Martin
> 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 



More information about the AccessD mailing list