By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,637 Members | 1,967 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,637 IT Pros & Developers. It's quick & easy.

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

P: 33
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?
Apr 4 '19 #1
Share this Question
Share on Google+
2 Replies


twinnyfo
Expert Mod 2.5K+
P: 3,282
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!
Apr 4 '19 #2

NeoPa
Expert Mod 15k+
P: 31,487
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.
Apr 4 '19 #3

Post your reply

Sign in to post your reply or Sign up for a free account.