hi Touk,
Are you putting >1 in the criteria cell of the column on the grid with Count? Access thinks the column you put the criteria is is text.
Are you using the Format function? That will turn a number into a string.
What is the SQL for the query? And if the query is based on another query, what is the SQL for that/those?
kind regards,
crystal
On 10/25/2020 10:53 PM, M Garcia via groups.io wrote:
Tried changing to Where but >1 changing to >"1".
On Sunday, October 25, 2020, 10:56:34 PM GMT-4, Paul Baldy <pbaldy@gmail.com> wrote:
You must be grouping on the date field as well. Try dropping that field, or changing Group By to Where if there's a criteria on that field.
PaulSent via mobile device
-------- Original message --------From: "M Garcia via groups.io" <toukey1=yahoo.com@groups.io>Date: 10/25/20 7:23 PM (GMT-08:00)Subject: Re: [MSAccessProfessionals] Report Help
Thanks Paul
I think I still have the query wrong.
When I run the query with group by on id# I get this:
Name ID# Daterec
Chris 1001 10/01/2020
Mary 2003 10/06/2020Mark 1020 10/02/2020
Mark 1020 10/10/2020Mark 1020 10/05/2020
Mark 1020 10/11/2020
On the report I also group by id# and did a count on daterec =Count([daterec]) so I get something like this:
Name ID# # of visits
Chris 1001 1
Mary 2003 1Mark 1020 4
I still can't seem to get rid of those where # of visits is 1
Where am I going wrong?
On Sunday, October 25, 2020, 09:19:15 PM GMT-4, Paul Baldy <pbaldy@gmail.com> wrote:
In the visits field of the query, put this in the criteria:
>1
PaulSent via mobile device
Hi,-------- Original message --------From: "M Garcia via groups.io" <toukey1=yahoo.com@groups.io>Date: 10/25/20 6:10 PM (GMT-08:00)Subject: [MSAccessProfessionals] Report Help
I have a report that list site visits with name, # of visits and ID#. In the report query I did a Group by id# so I get something like this:
Name ID# # of visits
Chris 1001 1
Mary 2003 1
Mark 1020 4
I want to be able to only show when the # of visits is more than 1.
Appreciate any assistance with this.
Thanks
Touk
Tidak ada komentar:
Posting Komentar