Prev: Using Access query data lookup values
Next: Select with Conditions
From: ياسر on 29 Mar 2010 08:24
Could any one help me
i have to make a crosstab to build a report from its results
the problem is
i have a table which the data will be taken from named Employee timesheet
all the employee's fills the field in so i have many fields and rows which
consist of the following data
employee - task - project name- department- work description - job tilte
-disicpline -regular time - overtime
thats all the required fields and all the employee's fill it every day
so what i need is to make a report builded from crosstab query to be like
this:
the row heading is:
employee
the column heading is:
project name
and then to calculate Both regular time and overtime (sum)
But the view of the query shows me all the employees and all the projects
names also sum of regular time
but whn i need to do report i want to make a parameter to get value for any
started and ended date this is problem 1
problem 2 :
every month there is a new projects will be added and i want the report to
be updated by them too.
problem 3:
there is too many projects in the crosstab query and the report will not
take all of them.
So will any helpfull one could help me please

From: Daryl S on 30 Mar 2010 10:49
ياسر-

Problem 1 -

You can add parameters to restrict the date range, even if the dates are not
shown in the results. In your query, add the date field and put the criteria
in the criteria row. You can make it dynamic like this:

Between [Enter Start Date] and [Enter End Date]

Problem 2 -

Each time you run the crosstab, it will pull from all the new data, so the
columns in the crosstab can change each time the data changes.

Problem 3 -

If reducing the time frame (problem 1) does not reduce the number of
projects to a reasonable number, then you can switch the rows for the
columns, as long as the number of employees is not too great. Otherwise you
may need to run several cross-tab reports, restricting each to a subset of
the projects.

--
Daryl S


"ياسر" wrote:

> Could any one help me
> i have to make a crosstab to build a report from its results
> the problem is
> i have a table which the data will be taken from named Employee timesheet
> all the employee's fills the field in so i have many fields and rows which
> consist of the following data
> employee - task - project name- department- work description - job tilte
> -disicpline -regular time - overtime
> thats all the required fields and all the employee's fill it every day
> so what i need is to make a report builded from crosstab query to be like
> this:
> the row heading is:
> employee
> the column heading is:
> project name
> and then to calculate Both regular time and overtime (sum)
> But the view of the query shows me all the employees and all the projects
> names also sum of regular time
> but whn i need to do report i want to make a parameter to get value for any
> started and ended date this is problem 1
> problem 2 :
> every month there is a new projects will be added and i want the report to
> be updated by them too.
> problem 3:
> there is too many projects in the crosstab query and the report will not
> take all of them.
> So will any helpfull one could help me please
>
 | 
Pages: 1
Prev: Using Access query data lookup values
Next: Select with Conditions