Sent: Tuesday, October 27, 2020 7:47 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Report Help
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
Chris 1001 10/01/2020
Mary 2003 10/06/2020
Mark 1020 10/10/2020
Mary 2003 1
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