UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
2 Pages V < 1 2  (Go to first unread post)
   Reply to this topicStart new topic
> Iif, Isnull, Nz, #num!(error), Access 2016    
 
   
Scooter1
post Feb 13 2018, 03:51 PM
Post#21



Posts: 62
Joined: 8-January 18



Sorry, I gave you the wrong date range. Here is the correct date ranges.

1/1/2018 to 1/31/2018
Mary Dunn

2/1/2018 to 2/28/2018
Jane Doe
Mandy Scooter


Go to the top of the page
 
RJD
post Feb 13 2018, 06:56 PM
Post#22


UtterAccess VIP
Posts: 9,242
Joined: 25-October 10
From: Gulf South USA


Right, I see the duplicates. This is caused in qryReportRecords using Group By in two places where Sum should have been used. See the query, and see the report now that those two changes have been made. You should be able to catch that by just looking at the query Total line in Design View.

HTH
Joe
Attached File(s)
Attached File  TechSupport_3_Rev9.zip ( 51.08K )Number of downloads: 2
 
Go to the top of the page
 
Scooter1
post Feb 14 2018, 10:03 PM
Post#23



Posts: 62
Joined: 8-January 18



RJD,

Thank you. This thread (project) is now 100% completed. Case closed!
Go to the top of the page
 
RJD
post Feb 14 2018, 10:06 PM
Post#24


UtterAccess VIP
Posts: 9,242
Joined: 25-October 10
From: Gulf South USA


You are welcome. Glad that works for you now.

Good luck with your project.

Regards,
Joe
Go to the top of the page
 
2 Pages V < 1 2


Custom Search


RSSSearch   Top   Lo-Fi    17th December 2018 - 12:07 AM