Parameter query

  • Thread starter Thread starter Jen
  • Start date Start date
J

Jen

Hi,
I wanted to pass a date from a form's combo box, which in
the query means >"03/26/2004" . How can I write a
parameter query to express "greater than" a certain date?

Any help is appreciated!
Jen
 
Instead of a parameter, you can refer directly to the combo box.

In the Criteria row of your query, under the date field, enter:
[Forms]![MyForm]![MyCombo]
Click to expand...
substituting the name of your form and combo.

If the combo is unbound, set its Format property to Short Date to help
Access understand the data type, and to prevent entry of invalid dates.
 
Hi Allen,
Thank you very much for your help.
Jen
-----Original Message-----
Instead of a parameter, you can refer directly to the combo box.

In the Criteria row of your query, under the date field, enter:
[Forms]![MyForm]![MyCombo]
Click to expand...
substituting the name of your form and combo.

If the combo is unbound, set its Format property to Short Date to help
Access understand the data type, and to prevent entry of invalid dates.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I wanted to pass a date from a form's combo box, which in
the query means >"03/26/2004" . How can I write a
parameter query to express "greater than" a certain date?

Any help is appreciated!
Jen
Click to expand...


.
Click to expand...
 
PARAMETER ParmDate DATETIME;
SELECT ... FROM TABLE WHERE THEDATE > ParmDate

Works fine too
Pieter
Jen said:
Hi Allen,
Thank you very much for your help.
Jen
-----Original Message-----
Instead of a parameter, you can refer directly to the combo box.

In the Criteria row of your query, under the date field, enter:
[Forms]![MyForm]![MyCombo]
Click to expand...
substituting the name of your form and combo.

If the combo is unbound, set its Format property to Short Date to help
Access understand the data type, and to prevent entry of invalid dates.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I wanted to pass a date from a form's combo box, which in
the query means >"03/26/2004" . How can I write a
parameter query to express "greater than" a certain date?

Any help is appreciated!
Jen
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top