Extracted Project to Access database now want to produce a report

[Tim Browne]

Extracted Project to Access database now want to produce a report of
projected hours how would one do that? I would like it to look like a
crosstab with rows being

20041211 20041218 20041225
etc .................
project name resource ttl hours ttl hours ttl hours


how would I do this ?

thanks

Tim Browne

(e-mail address removed)

 

[JackD]

I suggest that you post this in an access newsgroup. They are more likely to
be able to help you with this.

 

[Rod Gill]

Hi,

Search msdn.microsoft.com for articles on extracting time phased data. Once
you get that (consider extracting to a more readable table format), then use
Access's crosstab reports to produce what you want.