Cross Tab Query

[Rey]

I am trying to build a report that has week ending dates across the
top (example 12/22/07, 12/29/07, 1/5/08) and Driver Names down the
left side. I would like to have the report populate a scheduled date
that falls in between the range. My crosstab query only tries to
count or sum the dates.

 

[KARL DEWEY]

Please post example of your data and what the output of the query should look
like.

 

[Rey]

Please post example of your data and what the output of the query should look
like.
--
KARL DEWEY
Build a little - Test a little





- Show quoted text -

This is what I would want the query to output.

Name Emp_ID 1/5/08 1/12/08 1/19/08 1/26/08
and so on

Marin 125433 1/4/08
Smith 125432 1/3/08
Cole 256252 1/11/08
Britt 564742 1/10/08

The idea is that I can see how many employees I plan to train during
that week ending. Week ending being a calenadr week ending on
Saturday.


My query is returning this right now. It seems to be counting the
dates that fall into the range. I need to see the value (date).

Name Emp_ID 1/5/08 1/12/08 1/19/08 1/26/08
and so on

Marin 125433 1
Smith 125432 1
Cole 256252 1
Britt 564742 1


Thanks in advance for your help.

rey

 

[KARL DEWEY]

What calculation do you expect it to perform to arrive at those date? I do
not know of any such calculation.

You did not post the data that is in your table. Maybe there is more
information you expect it to use to arrive at those dates. Post examples of
the data the crosstable will work with.

Are there any constraints such as only 5 students per week/one per day?

 

[Rey]

What calculation do you expect it to perform to arrive at those date? I do
not know of any such calculation.

You did not post the data that is in your table. Maybe there is more
information you expect it to use to arrive at those dates. Post examples of
the data the crosstable will work with.

Are there any constraints such as only 5 students per week/one per day?
--
KARL DEWEY
Build a little - Test a little














- Show quoted text -

The dates are already there, I actually need it just to post the dates
that are already in the table and not try to count the dates.

Yes there would be only five per day.

My data is as follows.

Employee Name
Employee ID
Group
Work Status
OJSLast (this column holds a date that the training was performed)

I have another table that has day of the week and week ending date.
I'm sorry this might be vague, I'm not sure how you would like me to
post my data?

Thanks for all the help