Group:  Microsoft Access ยป microsoft.public.access.formscoding
Thread: Go To Record with filter

Geek News

Go To Record with filter
m stroup 12/11/2008 9:29:00 PM
tblBillets
Billet (PK) - Text with format XX-99,
frmBilletEdit
cboBillet with qry accessing tblBillets.

I want to find billets with only govt- in the primary key, but the message I
get is

The Microsoft Jet Database Engine does not recognize govt as a valid field
name or expression.

Any help you can offer is appreciated.


--
Teach me to fish! Thanks for the help.
Pax, M
Re: Go To Record with filter
Marshall Barton <marshbarton[ at ]wowway.com> 12/11/2008 11:03:04 PM
m stroup wrote:

[Quoted Text]
>tblBillets
> Billet (PK) - Text with format XX-99,
>frmBilletEdit
> cboBillet with qry accessing tblBillets.
>
>I want to find billets with only govt- in the primary key, but the message I
>get is
>
>The Microsoft Jet Database Engine does not recognize govt as a valid field
>name or expression.
>


The query criteria would be:

Like "govt-*"

--
Marsh
MVP [MS Access]

Home | Search | Terms | Imprint Contact
Newsgroups Reader - provided by WiredBox.Net