Help with a partial match query
in [Queries]
|
Prev: IIF and formatting
Next: E_lookup
From: Gina Whipp on 20 Mar 2010 13:01 Well, thank goodness John came along! -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Whirled.Peas" <peas(a)earth.org> wrote in message news:ho2o20$2mf$1(a)news.datemas.de... On Sat, 20 Mar 2010 09:24:34 -0400, John Spencer wrote: > whoops! Gina seems to have uncharacteristically gotten carried away > with the quotes. > LIKE [Enter first four digits] & "*" > > You might need to replace the * with a % if you have set up your > database to use ANSII-compliant SQL. > > > John Spencer > Access MVP 2002-2005, 2007-2010 > The Hilltop Institute > University of Maryland Baltimore County > > Gina Whipp wrote: >> Whirled.Peas, >> >> I think what you looking for is... >> >> LIKE "[Enter first four digits]" & "*" >> That did the trick! Thank you both for your help, it is very much appreciated. It took me a few tries to get the proper number of quotes in place, but John's string is correct. -- If you try, you can envision peas on earth.
From: John Spencer on 20 Mar 2010 15:32
No problem. I've had a few* of my postings refined** by others. * - an indeterminate number less than infinity ** - corrected politely sometimes with infinite patience. John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County Gina Whipp wrote: > Oh dear... THANKS John! > |