Parameter for date

[jk]

Hello,

I have a query which has three parameters but one parameter is not working
correctly and that is the date parameter. The criteria is Between [Start
date:] And [End date:] but it retrieves all records.Does parameter queries
for this type of criteria work when using multiple parameters?
thanks

 

[[MVP] S.Clark]

In the design view for the query, choose Query / Parameters from the main
menu. Assign a data type to each parameter. Sometimes it misinterprets the
types.

 

[jk]

THANKS

I continue to get the entire dates and not the specific ones i type into the
date parameter.Below is the sql for the where statement in parameters

WHERE (((InvoiceDetails1.DteComplete) Between [Start date:] And [End date:])
AND ((AdjCdes1.AdjDescRB)=[Enter three-letter code:])) OR
(((AdjCdes1.AdjDescWO)=[Enter three-letter code:]));

please advise if there is a problem in above...thanks

In the design view for the query, choose Query / Parameters from the main
menu. Assign a data type to each parameter. Sometimes it misinterprets the
types.

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

Hello,

I have a query which has three parameters but one parameter is not working
correctly and that is the date parameter. The criteria is Between [Start
date:] And [End date:] but it retrieves all records.Does parameter queries
for this type of criteria work when using multiple parameters?
thanks

 

[Duane Hookom]

PMFJI, try change the " OR " to " AND ".

--
Duane Hookom
MS Access MVP
--

THANKS

I continue to get the entire dates and not the specific ones i type into
the
date parameter.Below is the sql for the where statement in parameters

WHERE (((InvoiceDetails1.DteComplete) Between [Start date:] And [End
date:])
AND ((AdjCdes1.AdjDescRB)=[Enter three-letter code:])) OR
(((AdjCdes1.AdjDescWO)=[Enter three-letter code:]));

please advise if there is a problem in above...thanks

In the design view for the query, choose Query / Parameters from the main
menu. Assign a data type to each parameter. Sometimes it misinterprets
the
types.

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

Hello,

I have a query which has three parameters but one parameter is not working
correctly and that is the date parameter. The criteria is Between
[Start
date:] And [End date:] but it retrieves all records.Does parameter
queries
for this type of criteria work when using multiple parameters?
thanks

 

[jk]

Thanks Duane but the query just blows through the date criteria as if it did
not exist even with the "or" as in below view:

WHERE (((InvoiceDetails1.DteComplete) Between [Start date:] And [End date:])
AND ((AdjCdes1.AdjDescWO)=[Enter three-letter code:]) OR
((AdjCdes1.AdjDescRB)=[Enter three-letter code:])) OR
(((AdjCdes1.AdjDescWO)=[Enter three-letter code:]));

any advise is greatly appreciated...

PMFJI, try change the " OR " to " AND ".

--
Duane Hookom
MS Access MVP
--

THANKS

I continue to get the entire dates and not the specific ones i type into
the
date parameter.Below is the sql for the where statement in parameters

WHERE (((InvoiceDetails1.DteComplete) Between [Start date:] And [End
date:])
AND ((AdjCdes1.AdjDescRB)=[Enter three-letter code:])) OR
(((AdjCdes1.AdjDescWO)=[Enter three-letter code:]));

please advise if there is a problem in above...thanks

In the design view for the query, choose Query / Parameters from the main
menu. Assign a data type to each parameter. Sometimes it misinterprets
the
types.

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

Hello,

I have a query which has three parameters but one parameter is not
working
correctly and that is the date parameter. The criteria is Between
[Start
date:] And [End date:] but it retrieves all records.Does parameter
queries
for this type of criteria work when using multiple parameters?
thanks

 

[Duane Hookom]

Try:
WHERE InvoiceDetails1.DteComplete Between [Start date:] And [End date:]
AND (AdjCdes1.AdjDescWO=[Enter three-letter code:] OR
AdjCdes1.AdjDescRB=[Enter three-letter code:]);


--
Duane Hookom
MS Access MVP
--

Thanks Duane but the query just blows through the date criteria as if it
did
not exist even with the "or" as in below view:

WHERE (((InvoiceDetails1.DteComplete) Between [Start date:] And [End
date:])
AND ((AdjCdes1.AdjDescWO)=[Enter three-letter code:]) OR
((AdjCdes1.AdjDescRB)=[Enter three-letter code:])) OR
(((AdjCdes1.AdjDescWO)=[Enter three-letter code:]));

any advise is greatly appreciated...

PMFJI, try change the " OR " to " AND ".

--
Duane Hookom
MS Access MVP
--

THANKS

I continue to get the entire dates and not the specific ones i type
into
the
date parameter.Below is the sql for the where statement in parameters

WHERE (((InvoiceDetails1.DteComplete) Between [Start date:] And [End
date:])
AND ((AdjCdes1.AdjDescRB)=[Enter three-letter code:])) OR
(((AdjCdes1.AdjDescWO)=[Enter three-letter code:]));

please advise if there is a problem in above...thanks





:

In the design view for the query, choose Query / Parameters from the
main
menu. Assign a data type to each parameter. Sometimes it
misinterprets
the
types.

--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting

Hello,

I have a query which has three parameters but one parameter is not
working
correctly and that is the date parameter. The criteria is Between
[Start
date:] And [End date:] but it retrieves all records.Does parameter
queries
for this type of criteria work when using multiple parameters?
thanks