Re: [MSAccessProfessionals] Report Help

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.

Paul

Sent 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)

To: MSAccessProfessionals@groups.io

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/2020 

Mark       1020      10/02/2020
Mark       1020      10/10/2020 

Mark       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      1 

Mark       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

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