Database Query problem

[Mac@440th]

I am currently using an Access database built entirely using FP
Database Wizard (version: FP 2003). I have created a page (Page2)
displaying data using the Insert --> Database --> Results
functionality. The custom query I'm using is:

SELECT * FROM UMD WHERE AFSC like ':artAFSC::';

I also have a page (Page1) where a the user fills out a form with the
field 'PartAFSC'. When the form is submitted, I call an 'onSubmit'
script that concatenates an asterisk "*" to the PartAFSC field, thus
the user enters, for example, '037' and Page2 receives '037*'.
However, when the query on Page2 is committed, I get the message 'No
records found.' I know records do exists, as I can run the query
directly in Access using the following query:

SELECT * FROM UMD WHERE AFSC like '037*'

and get the data I need. I am obviously doing something wrong, but
can determine, what exactly, I is wrong. Any suggestions, ideas, etc.

Thanks in advance!

 

[Thomas A. Rowe]

Try:

SELECT * FROM UMD WHERE AFSC LIKE '%" & PartAFSC & "%'

And DO NOT add the * to the search string
--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

 

[Jon Spivey]

Hi,
You need to use % for like instead of * when you use Access on the web.
SELECT * FROM UMD WHERE AFSC like '037%'

Cheers,
Jon