Strange Behaviour

[rob_andy]

I'm using a linked table from Opera (Financial Package) that has around 4000 records. Now I do'nt need all the data so I tried to setup a query that only displayed records with an order number starting with C:

exp: IIf((Left([d_ihead]![ih_sorder],1)="C"),Trim(Right([d_ihead]![ih_sorder],((Len([d_ihead]![ih_sorder])-1)))),"")

criteria: <>""


So it doesn't show any that don't fit the above criteria. However I am getting some that are null still coming up in the query. Any ideas?

Thanks in advance. R

 

[bat17]

Try
IIf(Left([d_ihead]![ih_sorder],1)="C",True,False)
and then filter for True.

HTH


Peter

 

[rob_andy]

This sounds wierd but that does the same as my original, it does filter some falses out but some still get back through. R

 

[bat17]

Is this the only filter in the Query? just wondering if they could be creeping by on an OR somewhere.

Peter

 

[rob_andy]

Heres the SQL:

SELECT rInvoiceHead.ih_sorder, IIf(Left([rInvoiceHead]![ih_sorder],1)="C",True,False) AS Test, rInvoiceHead.ih_account, rInvoiceHead.ih_delad1, rInvoiceHead.ih_delad2, rInvoiceHead.ih_addr3, rInvoiceHead.ih_delad4, rInvoiceHead.ih_delad5, rInvoiceHead.ih_deladpc
FROM rInvoiceHead
WHERE (((IIf(Left([rInvoiceHead]![ih_sorder],1)="C",True,False))=True));

Thanks R

 

[bat17]

I cant see anything wrong with it
Are you getting "True" on the test column but blank on your ih_sorder column?

Peter