Report shows one result multiple times, Query for report showing all results

[JenniferM]

Hello everyone,
I have a single table, Tbl_ConsultTracker, which I am using to make a query and report (Qry_SearchResults and Rpt_SearchResults, respectively). Though other tables in my database have relationships to others, this one does not. It essentially contains fields "Consult_ID" (Autonumber/PK), "Consult_Name" (Text), "Consult_MRN" (Number), "Consult_Indication" (Text), "Consult_StartDate" (Date), and "Consult_EndDate" (Date).

Now, the query that I have selects all fields for this table (without any criteria applied, for now). At the moment, there are 25 records in Tbl_ConsultTracker, and the query returns 25 distinct records, just as they are recorded in the table. However, when I open my report (which has its record source set to Qry_SearchResults), it displays only the first result in the query, 25 times.

(How annoying!)

I've made other reports and not run into this problem before, and I'm not quite sure where I'm going wrong with this one. Does anyone have any ideas?

[twinnyfo]

Jennifer,

Could you post an image of your Report in design view? This might give us a place to start.

Does the Report behave the same way in both Report View and Print Preview?

Thanks!

[NeoPa]

That's indeed what we'll need to see Jennifer.
It seems clear that your report has something unusual set somewhere that is causing this unexpected behaviour but until we know what you've changed it's very hard to guess what that might be.
Another thing to try is to create a new report from scratch based on the query and test it before making any changes. I suspect that will show you the data you expect.