Re: [MSAccessProfessionals] Report Help

Touk (and others),

It would be nice if you could send out a "...got it fixed. Here's the resolution..." email so we could learn and not be left hanging 😉

Regards,

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of M Garcia via groups.io <toukey1=yahoo.com@groups.io>
Sent: Tuesday, October 27, 2020 7:47 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Report Help

 

Hi Crystal,

Thanks for your email below but I eventually figured out what I was doing incorrectly.

Thanks again.

On Tuesday, October 27, 2020, 05:49:45 AM AST, crystal (strive4peace) via groups.io <strive4peace2008=yahoo.com@groups.io> wrote:

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.

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