Easy Question - I think

brokenwh

Registered User.
Local time
Today, 15:06
Joined
Jul 31, 2003
Messages
15
Greetings:

I am trying to create a report that will list various project categories.

I am basing it off of a query that uses three tables (PONo, ProjectNo, Project SubNo).

The design is such that the PO# table has 4 sets of ProjectNo and Project SubNo lists (i.e. Project 1, Project 2, Project 3 and Project4)

I would like for my report to show the actual Project Name (referred to in the number) for each of the projects.

What would be the best way to do that? I hope this isn't tooooo confusing.
 
If the project name is in one of the tables in your query you can just add the field to the grid and then display it on the report. If it is in another table in the database you will need to bring that table into the query link to it and then bring the field into the grid.

Good Luck

GumbyD
 

Users who are viewing this thread

Back
Top Bottom