Crosstab query for gantt report

[NeoFax]

I would like to build a crosstab query that displays weeks as column
headings and tasks as row headings and value as something like
(iif(startDate and endDate fall within week,1,0). This would then
produce a pseudo gantt chart. I could then use a report to use
conditional formatting to color the boxes that have a value of 1 to
show the chart. How would I go about doing this?

 

[Duane Hookom]

I'm not sure how you want your gantt to look but there is a solution for
creating your crosstab at http://www.tek-tips.com/faqs.cfm?fid=5466.

There is a sample gantt chart in the calendar reports at
http://www.access.hookom.net/Samples.htm

 

[NeoFax]

I'm not sure how you want your gantt to look but there is a solution for
creating your crosstab athttp://www.tek-tips.com/faqs.cfm?fid=5466.

There is a sample gantt chart in the calendar reports athttp://www.access.hookom.net/Samples.htm
--
Duane Hookom
Microsoft Access MVP





- Show quoted text -

OK, this will work. However, how would I create a crosstab that the
value data of the crosstab is an expression that inputs 1 as the value
if the criteria is between dateA and dateB? Thanks!

 

[Duane Hookom]

Sorry either:
1) your question is too vague and lacks significant information
2) I'm not a mind reader
3) I can't see your MDB
4) I'm too confused to understand your needs

 

[NeoFax]

OK, here is what I would like:

Helo# Station# StartDate EndDate 10/1 10/8 10/15 10/22
10/29...
14704 1STA 10/15/2007 10/27/2007 0 0 1
1 0
14704 2STA 10/28/2007 11/10/2007 0 0 0
1 1
....

This would be in a crosstab query where the ones and zeros were
generated based on whether the startdate and enddate fell within the
column headings date range.