TheConstitution
03-13-2007, 04:14 AM
In my forename field I have entries with just the initial. I would like my query to filter out anything less than 2 characters. Does anyone know the criteria format? Many thanks
|
View Full Version : Greater than one character in query TheConstitution 03-13-2007, 04:14 AM In my forename field I have entries with just the initial. I would like my query to filter out anything less than 2 characters. Does anyone know the criteria format? Many thanks Dennisk 03-13-2007, 04:54 AM use the Len function TheConstitution 03-13-2007, 06:35 AM Thank you. I shall look a little more in depth in the Len expression as so far it has returned my query without any records. I shall read up a bit more. Many thanks for the pointer. TheConstitution 03-13-2007, 06:43 AM Done it! Many thanks again. |