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

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Run Query From Textbox Control Source In Report, Access 2016    
 
   
jczst21
post May 21 2019, 02:00 PM
Post#1



Posts: 68
Joined: 21-September 18



I'd like to sum a field of numbers in my report, but i need to add a "where" clause to that particular sum.
The rest of the report is unique counts of records in a dataset.
How do I filter a query for one textbox in a report?
Go to the top of the page
 
theDBguy
post May 21 2019, 02:16 PM
Post#2


Access Wiki and Forums Moderator
Posts: 75,519
Joined: 19-June 07
From: SunnySandyEggo


Hi. Not sure I understand the question but if the report is based on the same data as the query, then you should be able to add a calculated column in your query so you can then sum it.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
jczst21
post May 21 2019, 02:19 PM
Post#3



Posts: 68
Joined: 21-September 18



it's based on another query. If I include the extra field in the query that this report is tied to it, the unique value count for the people in the report will be wrong.
I am counting unique values in this report, but I also need to sum, values of time for visits for all the records as well.
Go to the top of the page
 
theDBguy
post May 21 2019, 02:21 PM
Post#4


Access Wiki and Forums Moderator
Posts: 75,519
Joined: 19-June 07
From: SunnySandyEggo


Then, perhaps a calculated control on your report is what you need. You can use any of the domain aggregate function in this calculated control, depending on your desired result.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
projecttoday
post May 21 2019, 04:06 PM
Post#5


UtterAccess VIP
Posts: 10,758
Joined: 10-February 04
From: South Charleston, WV


Maybe a new column using an Iif. Then sum the new column.

More specific information would be helpful.

--------------------
Robert Crouser
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    17th June 2019 - 06:26 PM