Need help creating form that duplicates the look of a report(sort of)

[T. Wilson]

I am building a database of employee records. On one of the tabbed sections
of a form displaying an employees data, I would like to display his/her
current time card.

The time card data is stored in a table constructed as follows:
ItemID Autonumber
EmployeeID Integer
Date Date
TaskID Integer
TimeSpent Double (overkill here I know)
Paid Yes/No

My main table, of course, stores the employee id, so that could be used to
link these two tables. From there, I would like a representation similar to
a time card, so that my display would look something like the following...

Date
TaskID TimeSpent
TaskID TimeSpent
TaskID TimeSpent
----------
TotalTimeSpent for this day
Date
TaskID TimeSpent
TaskID TimeSpent
TaskID TimeSpent
TaskID TimeSpent
----------
TotalTimeSpent for this day

etc., etc., until the end of the period and then...
=======
TotalTimeSpent for the period

Seems as though this is easy to do in a report, when you can create groups
on the report itself, but I'm at a loss to understand how I could do this on
a form. Any suggestions?

Todd Wilson

 

[RSGinCA]

Sounds like the job for a PivotTable. (That's all the help I can give you on
that subject though.)

Do you intend to be able to update data with this form or just display the
data? I don't think a form based on a PivotTable will allow you to update that
data.

Rick

 

[PC Datasheet]

Todd,

If you really need this and want someone to build it for you, contact me at the
email address below.

 

[T. Wilson]

PC Datasheet,

I was really just looking for a tip or an online example of something
similar. I can figure it out, it will just take longer to do so without an
example.

Thanks anyway,

Todd

 

[Cheryl Fischer]

Todd,

Have you looked at the goodies available at Access MVP Stephen Lebans'
website? Maybe his nifty Calendar control on the tab page that users could
click to select the Time Card date they want to view? Or, take a look at
his enhancements to conditional formatting.

hth,