another question

#1

how come wild cards "*" don't work in a linked table query? say I put in
[enter part number] as a input request, B* does not return all the part
numbers starting with B. That seems to work fine in a normal single table
query.

Thanks again

SR

#2

On Thu, 15 Feb 2007 17:15:53 -0500, "Steve Reinisch" <stever (AT) davis-eng (DOT) on.ca> wrote:

Quote:

how come wild cards "*" don't work in a linked table query? say I put in
[enter part number] as a input request, B* does not return all the part
numbers starting with B. That seems to work fine in a normal single table
query.

Try using the Percent sign instead:

B%

Scott McDaniel
scott (AT) takemeout_infotrakker (DOT) com
www.infotrakker.com

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

another question

comp.database.ms-access comp.database.ms-access

another question - 02-15-2007 , 05:15 PM

Re: another question - 04-30-2007 , 07:12 AM