Date parameters not working

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

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
 
This should Be :

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

or

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

- 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.
 
Indeed thx

- Raoul

Van T. Dinh said:
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)




Sarah said:
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
Click to expand...
Click to expand...
 
I apologize, I typed incorrectly in my nmessage. It is correct however in the
query. Any other suggestions?

Sarah

Van T. Dinh said:
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)




Sarah said:
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
Click to expand...
Click to expand...
 
Back
Top