J
Jorge
Anne -
Can we enter operators? such as >=11/22/04
Jorge
From: "Anne" <[email protected]>
Subject: Re: Query / Form - user enter
Date: Friday, November 12, 2004 4:40 AM
Jorge,
You have to enter a parameter in your query.
Select the field where you enter your date criteria. In the criteria
section, enter something like [Please enter the Payroll Date
(DD/MM/YY)].
When the user open the query, he will be prompt with the message in
the brackets. In fact the brackets create the parameter.
Now if you want to update it from a form, this is easy as well:
Let's say your form is called frmPayroll and the control with the
Payroll date: PayrollDate.
In the criteria of the date field in your query enter:
FORMS!frmPayroll!PayrollDate
The query will use the date in the control as a criteria. Make sure
that the control is not null.
Anne
Can we enter operators? such as >=11/22/04
Jorge
From: "Anne" <[email protected]>
Subject: Re: Query / Form - user enter
Date: Friday, November 12, 2004 4:40 AM
Jorge,
You have to enter a parameter in your query.
Select the field where you enter your date criteria. In the criteria
section, enter something like [Please enter the Payroll Date
(DD/MM/YY)].
When the user open the query, he will be prompt with the message in
the brackets. In fact the brackets create the parameter.
Now if you want to update it from a form, this is easy as well:
Let's say your form is called frmPayroll and the control with the
Payroll date: PayrollDate.
In the criteria of the date field in your query enter:
FORMS!frmPayroll!PayrollDate
The query will use the date in the control as a criteria. Make sure
that the control is not null.
Anne