hours of work on a sheet

[Guest]

hi
i wan to make a form on the basis of the table tasks and columns are
task id ,
task desc
manager id
start date
end date
project id


i need a form i n pivot style in which one side name of employee should be
there and on the other side i need project id and in between i need the hours
given to each employee for that particular project

or may be u can suggest the other design for the form also

pls mail me
and thanks in advance
pls help me i nee dit badly i tried it but i failed to do this

 

[pietlinden]

hi
i wan to make a form on the basis of the table tasks and columns are
task id ,
task desc
manager id
start date
end date
project id


i need a form i n pivot style in which one side name of employee should be
there and on the other side i need project id and in between i need the hours
given to each employee for that particular project

or may be u can suggest the other design for the form also

pls mail me
and thanks in advance
pls help me i nee dit badly i tried it but i failed to do this

You did? Did you read the help file on crosstab queries? Where's the
query SQL that you worked on?

If you really need help now, pay someone. Otherwise, read the help
file, work on it, and post what you tried.

 

[John Vinson]

hi
i wan to make a form on the basis of the table tasks and columns are
task id ,
task desc
manager id
start date
end date
project id


i need a form i n pivot style in which one side name of employee should be
there and on the other side i need project id and in between i need the hours
given to each employee for that particular project

Well, you certainly cannot do so given the information in that table.
You will also need a table of Employees and another table of
EmployeeAssignments, with fields for TaskID and EmployeeID. A Crosstab
query based on all three tables would be the basis for your report.

or may be u can suggest the other design for the form also

The Form is COMPLETELY IRRELEVANT. Forms are just windows, tools to
manage data in your Tables; your crosstab query, and your report, will
not involve the Form but will be based on your Tables.

A Form to enter data into these three tables would probably involve a
Form based on the Project table, with a continuous Subform based on
the EmployeeAssignment table with a combo box for the EmployeeID.
Crosstab queries are not updateable, but can be used for reporting.

pls mail me

Private EMail support is available to paying consulting clients. For
free, public newsgroup support - ask here, get your answer here. In
addition, we cannot email you because you did not post an email
address. (Don't - posting your address here will expose it to spammers
who will send you unwanted mail, and will NOT generally get you any
more or better help).

and thanks in advance
pls help me i nee dit badly i tried it but i failed to do this

Unless you explain what you tried, it's impossible for anyone to tell
you what you did wrong.

John W. Vinson[MVP]