crosstab report ?

rabatwork

New member
Local time
Today, 13:10
Joined
Sep 18, 2000
Messages
8
I am building a database to track multi-milestone events. The Left side of the report would be the milestone(s). The columns are headed by the event name, date, etc., and contain the status' of each milestone. I've tried a number of approaches but have been un-successful. I realize this may be a "rookie" report/query question, but then again, I'm a rookie. I'll probably need remedial assistance. Many thanks
 
It sounds like you are not doing a report, but building a table. I would suggest building the table first, then use that information for your queries and reports.
 
I assume the milestones are related to a project. You'll need at least two tables. One table to hold information about the project and the second to hold information about the milestones for a project. Your data entry form will be a main form that shows project information and a subform that shows milestone information.

The report should be based on a query that joins the project table to the milestone table with a left join on project number.
 
If you're still wanting information on crosstab reports, you might open the solution.mdb that comes with Access and look at some of the sample crosstab reports.

I developed some crosstab reports a few weeks ago, and the samples that came with Access proved very helpful. Saved me a lot of headaches, and turned a challenging task into a piece of cake.
 
Pat I know that this been a while ago, but I'm trying to do the same thing, are there any sample of this. Please assist. Thank Sir.

Pat Hartman said:
I assume the milestones are related to a project. You'll need at least two tables. One table to hold information about the project and the second to hold information about the milestones for a project. Your data entry form will be a main form that shows project information and a subform that shows milestone information.

The report should be based on a query that joins the project table to the milestone table with a left join on project number.
 

Users who are viewing this thread

Back
Top Bottom