Search results

Here is the process I follow. There is data preloaded so you can test it and hopefully see where I'm wrong. Run the Case Presentations (Announcement) make query. Enter desired date (4/23/2015). I use this because the parent table Case Presentations will hold many records, some with the dates...

The report is based on that table, as is my subreport. However, the subreport continues to duplicate an unspecified number of times. I'm not sure what I did wrong. I attached what my report design looks like.

SELECT DISTINCT [Case Presentions].Initials, [Case Presentions].MRN, [Case Presentions].Age, [Case Presentions].[M/F], [Case Presentions].Dx, [Case Presentions].[Path?], [Case Presentions].Presenter, [Case Presentions].Site, [Case Presentions].[Clinical Staging] INTO [Current Week...

My original query was a "make table" that my report and subform were pulling information from. I changed the query to be a regular query and made it unique. I am pulling information according to the date of the event. Since I changed it to unique, now it is repeatedly asking for a date for each...

I have a report that contains a subreport (form) that pulls records from a query. When I go to run the report, the records are there correctly, but the subreport continues to duplicate many times. How do I fix this?.....I hope I explained this right.