query needs to run twice to work

[Guest]

This query needs the same data to be entered twice to get a successful
result. Do I have to issue some kind of rewind before executing the query?
Thanks.

SELECT DISTINCTROW [Quote Entry].[Device Type], [Customer Address].[Company
Name], [Quote Quantities].Quantity, [Quote Quantities].Price, [Quote
Entry].[Date RFQ Mailed], [Quote Entry].[NHI RFQ Number]
FROM ([Customer Address] INNER JOIN ([Quote Quantities] INNER JOIN [Quote
Entry] ON [Quote Quantities].[NHI RFQ Number] = [Quote Entry].[NHI RFQ
Number]) ON [Customer Address].[Customer ID] = [Quote Entry].[Customer ID])
INNER JOIN [Rep Address] ON [Quote Entry].[Rep ID] = [Rep Address].[Rep ID]
WHERE ((([Quote Entry].[Device Type]) Like [Enter P/N or "*" for All]))
ORDER BY [Quote Quantities].Quantity, [Quote Entry].[Date RFQ Mailed],
[Customer Address].[Customer ID];

The data entry screen looks like

Enter Parameter Value
Enter p/n or "*" for all
*1386* this is the data that has to get entered
twice to get a result

 

[MGFoster]

This query needs the same data to be entered twice to get a successful
result. Do I have to issue some kind of rewind before executing the query?
Thanks.

The data entry screen looks like

Enter Parameter Value
Enter p/n or "*" for all
*1386* this is the data that has to get entered
twice to get a result

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You've changed the sorting/filtering of this query and saved those
changes. To correct: run the query then right click on the datasheet
(DS) and select Remove Filter/Sort. Close the query and click the Yes
button when asked if you want to save the changes.

In the future, whenever you open the query in DS view and sort or filter
DO NOT click the YES button when you close the query.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQnk8QYechKqOuFEgEQJ+bgCfYh3Qg/lYy43PbZz5Kzffqftn7X4AoPKf
SI/qjB2SxbOBoV66rW3lRTKj
=vdf3
-----END PGP SIGNATURE-----

 

[Guest]

That solved the problem. Thanks, youv'e saved me a lot of time.