Re: [MSAccessProfessionals] Report Help

In the visits field of the query, put this in the criteria:

>1

Paul

Sent via mobile device

-------- Original message --------

From: "M Garcia via groups.io" <toukey1=yahoo.com@groups.io>

Date: 10/25/20 6:10 PM (GMT-08:00)

To: MSAccessProfessionals@groups.io

Subject: [MSAccessProfessionals] Report Help

Hi,

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