[AccessD] Report Query

Martin

Try WHERE fld=[Form]!frmReports]![rptPremise] OR
Isnull([Form]!frmReports]![rptPremise])=True

-- Andy Lacey
http://www.minstersystems.co.uk 


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Caro
> Sent: 17 June 2004 08:10
> 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/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
> 
>