Go To Record with filter

M

m stroup

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.
 
M

Marshall Barton

m said:
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.
Click to expand...


The query criteria would be:

Like "govt-*"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

mailmerge recorded macro 0
Form not recognizing record added via SQL statement 2
Error Message "Cannot apply filter on one or more fields specified 0
How to use text filter in Access with SQL Server database 1
USING PARAMETERS IN A CROSSTAB QUERY 4
Conditional format of conflicting record 2
The Microsoft Jet database engine does not recognise... 4
DDL-Adding Autonumber limit 4

Top