Create Calendar in Query

[Arvin Villodres]

Hi and Happy Holidays to all!

There are two combo boxes in my form that would ask for
the begining and ending date respectively. I need to
create a query which would accept data based on the dates
that I have given. My query should look like this:

Combo Boxes
Date Begun: December 1, 2003
Date End: December 6, 2003

Query
EMPLOYEE 12/1/03 12/2/03 12/3/03 12/4/03 ... 12/6/03
MON TUE WED THU SAT
==========================================================
ARVIN | | | | |....|
==========================================================
LESLIE | | | | |
==========================================================
MHEL | | | | |
==========================================================

Is this possible? How can I do this?

Thank you very much for the help and Merry Christmas to
all.

 

[Duane Hookom]

You could probably do this with a Crosstab query. You won't get more than
one value as a column heading. There are download samples of both calendar
type reports and reports based on Crosstabs at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

 

[Arvin]

Thanks. I'll give it a try.

-----Original Message-----
You could probably do this with a Crosstab query. You won't get more than
one value as a column heading. There are download samples of both calendar
type reports and reports based on Crosstabs at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

--
Duane Hookom
MS Access MVP





.