Re: SQL parameter query not returning values

From: tbrogdon@xxxxxxxxx
Date: Thu, 29 Nov 2007 14:16:48 -0800 (PST)

What is the result of the query when you copy it to a query design
window (in SQL design). Of course with the parameters filled in?- Hide quoted text -

I made the following changes to the WHERE clause: #
"Production.ProductionDate=#" & Forms!frmProdReview!txtDate & "#"

and now it returns values (thank you) - however -

it returns all records from the selected Date (in this case
11/27/2007) but also returns records from 11/16/2007. I have records
from 11/14 - 11/27 as test records.

Tim

.

Follow-Ups:
- Re: SQL parameter query not returning values
  - From: Salad

References:
- SQL parameter query not returning values
  - From: tbrogdon
- Re: SQL parameter query not returning values
  - From: insomniux

Prev by Date: Re: Printing just the current record of a subform
Next by Date: Adding controls to a VBA Collection
Previous by thread: Re: SQL parameter query not returning values
Next by thread: Re: SQL parameter query not returning values
Index(es):
- Date
- Thread

Relevant Pages

AS clause causes DB failure
... A few weeks ago I created a few test records with some new data manipulation ... screens I had created using the DRW in FP 2002. ... SELECT statement in my whole site with an AS clause was also failing. ... I contacted tech support at my hosting provider, ...
(microsoft.public.frontpage.programming)
Re: SQL parameter query not returning values
... from 11/14 - 11/27 as test records. ... ' Define the parameters clause. ... ' Define an SQL statement with the parameters ...
(comp.databases.ms-access)