Using Dates as Criteria to Display Records in FORM

Employees who work on a Client File will enter the payroll information on a
continuous form linked to the Client Record. To edit employee information,
the employee record is accessed through the Client Record.

At the end of a pay period, I would like to have access to a list of all
employees who have worked during that pay period so I have designed a form to
display a list of part time employees, sorted by date worked, showing the
hours they worked. When I open the form, all of the records in the table are
displayed. I would like to display only those employees who have worked
within a particular pay period. How can I make that happen?


To access a REPORT that displays the identical information I need,
I set the criteria to…..
=[forms]![msgReportRange]![Between] And =[forms]![msgReportRange]![And]

And then enter the begindate and enddate of the payroll period. But I
cannot edit the information in a report.

How can I open the newly designed FORM? Any thoughts?

R Marko

the same way you did with a report. if you're opening the form from another
form (a switchboard or main menu, perhaps), then you can add controls to
that first form for the user to enter the start/end dates, and refer to
those form controls in the query underlying the second form.

hth


"R Marko" wrote in message
...
Employees who work on a Client File will enter the payroll information on
a
continuous form linked to the Client Record. To edit employee
information,
the employee record is accessed through the Client Record.

At the end of a pay period, I would like to have access to a list of all
employees who have worked during that pay period so I have designed a form
to
display a list of part time employees, sorted by date worked, showing the
hours they worked. When I open the form, all of the records in the table
are
displayed. I would like to display only those employees who have worked
within a particular pay period. How can I make that happen?


To access a REPORT that displays the identical information I need,
I set the criteria to...
=[forms]![msgReportRange]![Between] And =[forms]![msgReportRange]![And]

And then enter the begindate and enddate of the payroll period. But I
cannot edit the information in a report.

How can I open the newly designed FORM? Any thoughts?

R Marko

Thank you for your response.

How can I do that? I already have a form that will request a begin and end
date. Where do I enter the criteria?

"tina" wrote:

the same way you did with a report. if you're opening the form from another
form (a switchboard or main menu, perhaps), then you can add controls to
that first form for the user to enter the start/end dates, and refer to
those form controls in the query underlying the second form.

hth


"R Marko" wrote in message
...
Employees who work on a Client File will enter the payroll information on
a
continuous form linked to the Client Record. To edit employee
information,
the employee record is accessed through the Client Record.

At the end of a pay period, I would like to have access to a list of all
employees who have worked during that pay period so I have designed a form
to
display a list of part time employees, sorted by date worked, showing the
hours they worked. When I open the form, all of the records in the table
are
displayed. I would like to display only those employees who have worked
within a particular pay period. How can I make that happen?


To access a REPORT that displays the identical information I need,
I set the criteria to...
=[forms]![msgReportRange]![Between] And =[forms]![msgReportRange]![And]

And then enter the begindate and enddate of the payroll period. But I
cannot edit the information in a report.

How can I open the newly designed FORM? Any thoughts?

R Marko

in the query underlying the form.

hth


"R Marko" wrote in message
...
Thank you for your response.

How can I do that? I already have a form that will request a begin and
end
date. Where do I enter the criteria?

"tina" wrote:

the same way you did with a report. if you're opening the form from
another
form (a switchboard or main menu, perhaps), then you can add controls to
that first form for the user to enter the start/end dates, and refer to
those form controls in the query underlying the second form.

hth


"R Marko" wrote in message
...
Employees who work on a Client File will enter the payroll information
on
a
continuous form linked to the Client Record. To edit employee
information,
the employee record is accessed through the Client Record.

At the end of a pay period, I would like to have access to a list of
all
employees who have worked during that pay period so I have designed a
form
to
display a list of part time employees, sorted by date worked, showing
the
hours they worked. When I open the form, all of the records in the
table
are
displayed. I would like to display only those employees who have
worked
within a particular pay period. How can I make that happen?


To access a REPORT that displays the identical information I need,
I set the criteria to...
=[forms]![msgReportRange]![Between] And
=[forms]![msgReportRange]![And]

And then enter the begindate and enddate of the payroll period. But I
cannot edit the information in a report.

How can I open the newly designed FORM? Any thoughts?

R Marko