multiple copies of a record when a report is opened

[syrbellringer261]

I built a query and a report, to show all but our completed projects. I get the results I asked for, except, there is 13 copies of the same record per page. I've looked in the query and the report over and over and can't see where the extra copies are coming from. This gives me 271 pages, which I know would be a lot less if I could get more then one record on a page, and not have them being the same record.

Has anyone come across this problem? Any thoughts or comments on how to fix this is greatly appreciated.

Thank you,

Susan

 

[GingerR]

Please post your query's SQL string. Also brief desc of your table structure. Maybe you just need to set the TOTALS on the query?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[syrbellringer261]

Thank you Ginger here is the SQL string

SELECT Master.Proj_ID, Master.Proj_Name, Master.Description AS Master_Description, Master.Leader, Master.Team_Member1, Master.Team_Member2, Master.Team_Others, Master.Client, Master.[Start Date], Master.Deadline, Master.VictoryCondition, Master.PathDev, Master.PathPub, Master.WhoseBall, Master.Priority, Master.PursuitStatus, Master.ActivityType, Master.Project AS Master_Project, Master.PathAPP, Master.internal, Master.Status AS Master_Status, Master.[Current Report], PursuitStatus.Status AS PursuitStatus_Status, PursuitStatus.Project AS PursuitStatus_Project, PursuitStatus.Description AS PursuitStatus_Description
FROM Master, PursuitStatus
WHERE (((Master.PursuitStatus)<>"Complete"));

The Table I'm working with is our Master table and is on the back end. There are 22 Columns most are text fields except for Proj_ID which is the primary key & AutoNumber, Deadline which is date and Current Report which is Y/N.

I hope I gave you enough information about the table structure.

Thanks again
Susan

 

[GingerR]

You don't have any join between the two tables? So I'm guessing that there are 13 rows in one of those tables, and so you are getting 13 rows of duplicates for each one row in the other table, right? Looks like you need to make a join on PursuitStatus?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[syrbellringer261]

Ginger,

Thank you, I guess I over looked the Obvious. Funny how it worked once I linked the tables.

Thanks again, and have a Happy Thanksgiving.

Susan