Minggu, 25 Oktober 2020

Re: [MSAccessProfessionals] Report Help

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

Tidak ada komentar:

Posting Komentar