creating a date range based form

[Guest]

Hope the subject is sufficient. Here is what is going on.

I need to create a form that will display data within a date range... no
biggie. However, I'd like to keep it as close to the example I have been
working off of, which is very similar to a datasheet view or crosstab style.

Information I am going to pull is:
EmployeeID (should be a hidden field), Employee name (concatenated data),
Pay Rate, Hours Worked, and then sum of payrate * hours worked. Then, I need
to sum all of the pay amounts (sum of payrate * hours worked) on the form
footer (which I assume will just be a dsum).

Is there a way to do this and keep it in a crosstab-like style?

Hope that's clear enough. Any help is greatly appreciated!

 

[Guest]

Also should say that I want to group the info by employee and only have one
row of data per employee. So I need a total of hours worked and pay rates
per day. There is a possibility that an employee could have a different pay
rate assigned based upon the work they did.