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 '::PartAFSC::';

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!

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
==============================================


"Mac@440th" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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 '::PartAFSC::';
>
> 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!
>

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

"Mac@440th" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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 '::PartAFSC::';
>
> 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!
>