query execution

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I enter a value for a query execution, I get no results. If I enter the
same value again, I get the right output.

What can cause this? Thanks.
 
When I enter a value for a query execution, I get no results. If I enter the
same value again, I get the right output.

What can cause this? Thanks.
Click to expand...

Could you please explain the context? Where are you "entering the
value"? In VBA code, as a criterion in a query, what? Perhaps you
could post the SQL of the offending query.

Remember - YOU can see your computer screen. We cannot.

John W. Vinson[MVP]
 
Here's the query.

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


Thanks again.
 
Back
Top