Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #11439

Re: Any idea why my SQL statement fails

Show all headers | View raw

Am 06.01.2016 um 16:51 schrieb Patrick Finucane:
> Using Access 2013.  I have a order details table called All_Itms.  It contains two fields in it; OID (order number id) and SON (sequential order number)
>
> If my Sql statment is
>   SELECT All_Itms.* FROM All_Itms WHERE (((All_Itms.SON)="109130"));
> it returns NO records.  FAIL
>
> The OID is 311 for this order.  If I enter
>    SELECT All_Itms.* FROM All_Itms WHERE (((All_Itms.OID)=311));
> I get 6 records, which is correct.  I look at the SON column and they all have 109130 in it.
>
> Any idea why one works and the other fails?  Or is this simply an MS-Access 2013 screwup?
>
Hi Patrick,

assuming the entry SON="109130" exists, check whether the are no 
additional blanks preceding or following the field value.

Ulrich

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Any idea why my SQL statement fails Patrick Finucane <patrickfinucanetx@gmail.com> - 2016-01-06 07:51 -0800
  Re: Any idea why my SQL statement fails Ulrich Möller <knobbi38@arcor.de> - 2016-01-06 17:16 +0100
    Re: Any idea why my SQL statement fails Patrick Finucane <patrickfinucanetx@gmail.com> - 2016-01-06 08:32 -0800

csiph-web