Time Sheet Report 1

[mhoque]

Please forgive my "not so bright" question. I am a new user of ACCESS. My DB is designed to track project hours. I would like to create a report to show

Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8
Proj# ProjName Hrs(mon)Hrs(T) Hrs(W) Hrs(Th) Hrs(F) Hrs(Total)

I tried to use Crosstab query but get error message: "Too many column heading...."
How may I accomplish this goal? Please help. Thanks.

 

[mhoque]

1) I used this instead and it worked: =Sum(nz([Mon],0)+nz([Tue],0)+nz([Wed],0)+nz([Thu],0)+nz([FRI],0))

Is it not a right way to do so?

2) I tried adding the “Title” field as a Row Heading and ran into problem. Didn’t work for me. How to use dlookup() formula. Title is a text field.

I shall try #3 and shall get back to you soon. Thanks.

 

[GingerR]

2) Assuming that TITLE is a field in table Employee, i just added it to the query, selected GROUP BY in the "TOTAL" row, set it as a ROW HEADING, and then it was fine.

Is TITLE in the Employee table? You say "it didn't work"...HOW didn't it work?

If you've done all of the above and it still doesn't work, look up DLOOKUP() in HELP. It'd be something like:

=Dlookup("Title","TableNameHere","[EmployeeID] = " & EmployeeID)


This reads: Look up the value in the field "Title", in the table "TableNameHere", where the value of the field [EmployeeID] = the value of Employee ID on the current object (the report, in this case).

1) It's right if it works. That's all that matters. Don't forget Sat and Sun.


Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html