Date parameters not working

[Guest]

Hello, I am running a query the selects records based on a number of
different criteria. The date range and craft a supplied by a form. The Unit
is determined by the query.

The problem I am having is that the date range is not working. I am getting
no errors. I just get all the records instead of the range I selected in my
form. Here's what is in the criteria.

between [forms!][frmrptdata][txtstart] and [form!][frmrptdata][txtend]

Any help would be greatly appreciated

 

[Guest]

This should Be :

BETWEEN [forms]![frmrptdata]![txtstart] AND [form]![frmrptdata]![txtend]

or

BETWEEN forms("frmrptdata").txtstart AND forms("frmrptdata").txtEnd

- Raoul

 

[Van T. Dinh]

BETWEEN Forms!frmrptdata!txtstart
AND Forms!frmrptdata!txtend

Be careful with spelling. You left out the "s" in the second "forms" in
your post and the other respondent did likewise.

 

[Guest]

Indeed thx

- Raoul

BETWEEN Forms!frmrptdata!txtstart
AND Forms!frmrptdata!txtend

Be careful with spelling. You left out the "s" in the second "forms" in
your post and the other respondent did likewise.

--
HTH
Van T. Dinh
MVP (Access)

Hello, I am running a query the selects records based on a number of
different criteria. The date range and craft a supplied by a form. The Unit
is determined by the query.

The problem I am having is that the date range is not working. I am getting
no errors. I just get all the records instead of the range I selected in my
form. Here's what is in the criteria.

between [forms!][frmrptdata][txtstart] and [form!][frmrptdata][txtend]

Any help would be greatly appreciated

 

[Guest]

I apologize, I typed incorrectly in my nmessage. It is correct however in the
query. Any other suggestions?

Sarah

BETWEEN Forms!frmrptdata!txtstart
AND Forms!frmrptdata!txtend

Be careful with spelling. You left out the "s" in the second "forms" in
your post and the other respondent did likewise.

--
HTH
Van T. Dinh
MVP (Access)

Hello, I am running a query the selects records based on a number of
different criteria. The date range and craft a supplied by a form. The Unit
is determined by the query.

The problem I am having is that the date range is not working. I am getting
no errors. I just get all the records instead of the range I selected in my
form. Here's what is in the criteria.

between [forms!][frmrptdata][txtstart] and [form!][frmrptdata][txtend]

Any help would be greatly appreciated

 

[Van T. Dinh]

So have you tried my suggestion in the previous reply?