Groups > comp.databases.ms-access > #11053 > unrolled thread

Row numbers in a query to keep track of absences?

Started by	sara.mallicoat@genco.com
First post	2015-09-01 13:23 -0700
Last post	2015-09-24 01:00 +0200
Articles	11 on this page of 31 — 5 participants

Back to article view | Back to comp.databases.ms-access

  Row numbers in a query to keep track of absences? sara.mallicoat@genco.com - 2015-09-01 13:23 -0700
    Re: Row numbers in a query to keep track of absences? Ulrich Möller <knobbi38@arcor.de> - 2015-09-02 02:39 +0200
      Re: Row numbers in a query to keep track of absences? sara.mallicoat@genco.com - 2015-09-02 08:08 -0700
        Re: Row numbers in a query to keep track of absences? Ulrich Möller <knobbi38@arcor.de> - 2015-09-02 19:47 +0200
          Re: Row numbers in a query to keep track of absences? sara.mallicoat@genco.com - 2015-09-04 10:27 -0700
            Re: Row numbers in a query to keep track of absences? Ulrich Möller <knobbi38@arcor.de> - 2015-09-04 20:05 +0200
              Re: Row numbers in a query to keep track of absences? sara.mallicoat@genco.com - 2015-09-04 11:17 -0700
              Re: Row numbers in a query to keep track of absences? sara.mallicoat@genco.com - 2015-09-04 11:37 -0700
                Re: Row numbers in a query to keep track of absences? Ulrich Möller <knobbi38@arcor.de> - 2015-09-04 22:11 +0200
                  Re: Row numbers in a query to keep track of absences? Ulrich Möller <knobbi38@arcor.de> - 2015-09-04 23:59 +0200
                    Re: Row numbers in a query to keep track of absences? sara.mallicoat@genco.com - 2015-09-09 12:21 -0700
                      Re: Row numbers in a query to keep track of absences? Ulrich Möller <knobbi38@arcor.de> - 2015-09-09 23:37 +0200
    Re: Row numbers in a query to keep track of absences? sara.mallicoat@genco.com - 2015-09-10 10:19 -0700
      Re: Row numbers in a query to keep track of absences? sara.mallicoat@genco.com - 2015-09-16 09:12 -0700
        Re: Row numbers in a query to keep track of absences? Patrick Finucane <patrickfinucanetx@gmail.com> - 2015-09-16 09:50 -0700
        Re: Row numbers in a query to keep track of absences? Ulrich Möller <knobbi38@arcor.de> - 2015-09-16 21:02 +0200
          Re: Row numbers in a query to keep track of absences? "Phil" <phil@stantonfamily.co.uk> - 2015-09-16 20:42 +0100
          Re: Row numbers in a query to keep track of absences? sara.mallicoat@genco.com - 2015-09-16 13:12 -0700
            Re: Row numbers in a query to keep track of absences? sara.mallicoat@genco.com - 2015-09-16 13:18 -0700
              Re: Row numbers in a query to keep track of absences? Ulrich Möller <knobbi38@arcor.de> - 2015-09-17 04:05 +0200
                Re: Row numbers in a query to keep track of absences? sara.mallicoat@genco.com - 2015-09-17 13:49 -0700
                  Re: Row numbers in a query to keep track of absences? Ulrich Möller <knobbi38@arcor.de> - 2015-09-18 11:21 +0200
                    Re: Row numbers in a query to keep track of absences? sara.mallicoat@genco.com - 2015-09-18 08:48 -0700
                      Re: Row numbers in a query to keep track of absences? Ulrich Möller <knobbi38@arcor.de> - 2015-09-18 19:44 +0200
                        Re: Row numbers in a query to keep track of absences? Sara M <sara.mallicoat@genco.com> - 2015-09-18 13:43 -0700
                        Re: Row numbers in a query to keep track of absences? Sara M <sara.mallicoat@genco.com> - 2015-09-22 11:43 -0700
                          Re: Row numbers in a query to keep track of absences? Ulrich Möller <knobbi38@arcor.de> - 2015-09-23 00:39 +0200
                            Re: Row numbers in a query to keep track of absences? Sara M <sara.mallicoat@genco.com> - 2015-09-23 06:11 -0700
                              Re: Row numbers in a query to keep track of absences? Ulrich Möller <knobbi38@arcor.de> - 2015-09-23 18:23 +0200
                                Re: Row numbers in a query to keep track of absences? Sara M <sara.mallicoat@genco.com> - 2015-09-23 09:29 -0700
                          Re: Row numbers in a query to keep track of absences? Ulrich Möller <knobbi38@arcor.de> - 2015-09-24 01:00 +0200

Page 2 of 2 — ← Prev page 1 [2]

#11102

From	sara.mallicoat@genco.com
Date	2015-09-17 13:49 -0700
Message-ID	<595ece3a-9cf3-437b-a371-d3389c7457f3@googlegroups.com>
In reply to	#11100

I don't know what is wrong, but the field comes up blank?  The same thing that happens when I use the dsum function.  What am I doing wrong?

[toc] | [prev] | [next] | [standalone]

#11103

From	Ulrich Möller <knobbi38@arcor.de>
Date	2015-09-18 11:21 +0200
Message-ID	<mtgkv3$glo$1@dont-email.me>
In reply to	#11102

Am 17.09.2015 um 22:49 schrieb sara.mallicoat@genco.com:
> I don't know what is wrong, but the field comes up blank?  The same thing that happens when I use the dsum function.  What am I doing wrong?

Fieldnames or Fieldtypes maybe wrong. 'Point' must be of type number. 
Check your tabledefinition. Test the subselect alone in the qbe without 
the where condition.

Ulrich

[toc] | [prev] | [next] | [standalone]

#11106

From	sara.mallicoat@genco.com
Date	2015-09-18 08:48 -0700
Message-ID	<4cb7309f-9c69-4018-876c-58487f3df3d7@googlegroups.com>
In reply to	#11103

I put this back in my test database because I know I am not ready to roll it out again yet.  

In doing so and playing around and adding chunks I got the RunSum to work, but it is not looking at teammates at all.  

CODE:
SELECT t1.ID, t1.Teammate, t1.DateOfAbsence, t1.prevDateOfAbs, t1.DiffAbs, t1.Points, t1.AttendanceCredits, (SELECT SUM([Points]) FROM [DaysSinceLastAbs_RUNNING TOTAL] AS t2 WHERE t1.Teammate = t2.Teammate AND t1.DateOfAbsence >= t2.DateOfAbsence) AS RunSum
FROM [DaysSinceLastAbs_RUNNING TOTAL] AS t1;

Output:
IDTeammateDateOfAbsence	prevDateOfAbsDiffAbsPointsAttendanceCredits RunSum
1	Ben	1/20/2015			1	0	12
2	Ben	1/25/2015	20-Jan-15	5	1	0	12
3	Ben	4/20/2015	25-Jan-15	85	1	0.5	12
4	Ben	4/21/2015	20-Apr-15	1	0	0	12
21	Brandon	2/1/2015			1	0	12
22	Brandon	2/13/2015	01-Feb-15	12	0.5	0	12
23	Brandon	3/5/2015	13-Feb-15	20	0.5	0	12
24	Brandon	3/13/2015	05-Mar-15	8	1	0	12
25	Brandon	3/14/2015	13-Mar-15	1	0	0	12
26	Brandon	5/24/2015	14-Mar-15	71	0	0.5	12
6	Chris	2/15/2015			1	0	12
7	Chris	2/16/2015	15-Feb-15	1	0	0	12
8	Chris	2/28/2015	16-Feb-15	12	0	0	12
20	Chris	8/20/2015	28-Feb-15	173	0	1.5	12
13	Chris	8/22/2015	20-Aug-15	2	0.5	0	12
14	Don	1/25/2015			1	0	12
15	Don	1/26/2015	25-Jan-15	1	0	0	12
16	Don	3/20/2015	26-Jan-15	53	1	0.5	12
17	Don	5/31/2015	20-Mar-15	72	1	0.5	12
18	Don	6/10/2015	31-May-15	10	0.5	0	12
19	Don	8/20/2015	10-Jun-15	71	1	0.5	12

[toc] | [prev] | [next] | [standalone]

#11107

From	Ulrich Möller <knobbi38@arcor.de>
Date	2015-09-18 19:44 +0200
Message-ID	<mthiee$59e$1@dont-email.me>
In reply to	#11106

Am 18.09.2015 um 17:48 schrieb sara.mallicoat@genco.com:
> I put this back in my test database because I know I am not ready to roll it out again yet.
>
> In doing so and playing around and adding chunks I got the RunSum to work, but it is not looking at teammates at all.
>
> CODE:
> SELECT t1.ID, t1.Teammate, t1.DateOfAbsence, t1.prevDateOfAbs, t1.DiffAbs, t1.Points, t1.AttendanceCredits, (SELECT SUM([Points]) FROM [DaysSinceLastAbs_RUNNING TOTAL] AS t2 WHERE t1.Teammate = t2.Teammate AND t1.DateOfAbsence >= t2.DateOfAbsence) AS RunSum
> FROM [DaysSinceLastAbs_RUNNING TOTAL] AS t1;
>
> Output:
> IDTeammateDateOfAbsence	prevDateOfAbsDiffAbsPointsAttendanceCredits RunSum
> 1	Ben	1/20/2015			1	0	12
> 2	Ben	1/25/2015	20-Jan-15	5	1	0	12
> 3	Ben	4/20/2015	25-Jan-15	85	1	0.5	12
> 4	Ben	4/21/2015	20-Apr-15	1	0	0	12
> 21	Brandon	2/1/2015			1	0	12
> 22	Brandon	2/13/2015	01-Feb-15	12	0.5	0	12
> 23	Brandon	3/5/2015	13-Feb-15	20	0.5	0	12
> 24	Brandon	3/13/2015	05-Mar-15	8	1	0	12
> 25	Brandon	3/14/2015	13-Mar-15	1	0	0	12
> 26	Brandon	5/24/2015	14-Mar-15	71	0	0.5	12
> 6	Chris	2/15/2015			1	0	12
> 7	Chris	2/16/2015	15-Feb-15	1	0	0	12
> 8	Chris	2/28/2015	16-Feb-15	12	0	0	12
> 20	Chris	8/20/2015	28-Feb-15	173	0	1.5	12
> 13	Chris	8/22/2015	20-Aug-15	2	0.5	0	12
> 14	Don	1/25/2015			1	0	12
> 15	Don	1/26/2015	25-Jan-15	1	0	0	12
> 16	Don	3/20/2015	26-Jan-15	53	1	0.5	12
> 17	Don	5/31/2015	20-Mar-15	72	1	0.5	12
> 18	Don	6/10/2015	31-May-15	10	0.5	0	12
> 19	Don	8/20/2015	10-Jun-15	71	1	0.5	12
I have just tested your sql and it works as expected. Check your input 
table for invalid types or extra characters (e.x. Blanks), particular on 
the fields teammate and DateOfAbsence.

Here you can find my testdata: http://1drv.ms/1W8ClJK

Ulrich

[toc] | [prev] | [next] | [standalone]

#11108

From	Sara M <sara.mallicoat@genco.com>
Date	2015-09-18 13:43 -0700
Message-ID	<35b4624c-152a-4f55-9cd7-6eec0965cbd9@googlegroups.com>
In reply to	#11107

On Friday, September 18, 2015 at 12:44:40 PM UTC-5, Ulrich Möller wrote:
> Am 18.09.2015 um 17:48 schrieb sara.mallicoat@genco.com:
> > I put this back in my test database because I know I am not ready to roll it out again yet.
> >
> > In doing so and playing around and adding chunks I got the RunSum to work, but it is not looking at teammates at all.
> >
> > CODE:
> > SELECT t1.ID, t1.Teammate, t1.DateOfAbsence, t1.prevDateOfAbs, t1.DiffAbs, t1.Points, t1.AttendanceCredits, (SELECT SUM([Points]) FROM [DaysSinceLastAbs_RUNNING TOTAL] AS t2 WHERE t1.Teammate = t2.Teammate AND t1.DateOfAbsence >= t2.DateOfAbsence) AS RunSum
> > FROM [DaysSinceLastAbs_RUNNING TOTAL] AS t1;
> >
> > Output:
> > IDTeammateDateOfAbsence	prevDateOfAbsDiffAbsPointsAttendanceCredits RunSum
> > 1	Ben	1/20/2015			1	0	12
> > 2	Ben	1/25/2015	20-Jan-15	5	1	0	12
> > 3	Ben	4/20/2015	25-Jan-15	85	1	0.5	12
> > 4	Ben	4/21/2015	20-Apr-15	1	0	0	12
> > 21	Brandon	2/1/2015			1	0	12
> > 22	Brandon	2/13/2015	01-Feb-15	12	0.5	0	12
> > 23	Brandon	3/5/2015	13-Feb-15	20	0.5	0	12
> > 24	Brandon	3/13/2015	05-Mar-15	8	1	0	12
> > 25	Brandon	3/14/2015	13-Mar-15	1	0	0	12
> > 26	Brandon	5/24/2015	14-Mar-15	71	0	0.5	12
> > 6	Chris	2/15/2015			1	0	12
> > 7	Chris	2/16/2015	15-Feb-15	1	0	0	12
> > 8	Chris	2/28/2015	16-Feb-15	12	0	0	12
> > 20	Chris	8/20/2015	28-Feb-15	173	0	1.5	12
> > 13	Chris	8/22/2015	20-Aug-15	2	0.5	0	12
> > 14	Don	1/25/2015			1	0	12
> > 15	Don	1/26/2015	25-Jan-15	1	0	0	12
> > 16	Don	3/20/2015	26-Jan-15	53	1	0.5	12
> > 17	Don	5/31/2015	20-Mar-15	72	1	0.5	12
> > 18	Don	6/10/2015	31-May-15	10	0.5	0	12
> > 19	Don	8/20/2015	10-Jun-15	71	1	0.5	12
> I have just tested your sql and it works as expected. Check your input 
> table for invalid types or extra characters (e.x. Blanks), particular on 
> the fields teammate and DateOfAbsence.
> 
> Here you can find my testdata: http://1drv.ms/1W8ClJK
> 
> Ulrich

Ulrich - that's for the tip.  There are no blanks.  So, I tried the first query that I called qryAttendance which takes the Attendance and sorts on the criteria I need which feeds the DaysSinceLastAbs and when I switched to that query everything worked out as planned.  I am not sure why that query was giving me grief.  Now, I will have to use the same approach for the abs creds and see if this in fact gives me their running total!  Baby steps and I wouldn't be here without help from this group - thank you!  We will concur this 45 day credit thing!!  Thank you so much!

[toc] | [prev] | [next] | [standalone]

#11126

From	Sara M <sara.mallicoat@genco.com>
Date	2015-09-22 11:43 -0700
Message-ID	<c67ef2ac-90a0-42f8-9954-7f6d23108925@googlegroups.com>
In reply to	#11107

Ulrich - I was going to send you my file I couldn't upload it where you sent the link.  

I got the point total to sum which I thought I could adjust the code and get the credits to sum up and then simply join the two and get what I need, but for whatever reason, my credits will not sum by teammates - it sums the total for all entries...  what am I doing wrong... I have tried a million different ways...

Can I email you the file or is this easiest?

Code:
SELECT t1.ID, t1.Teammate, t1.DateOfAbsence, t1.AttendanceCredits, t1.TotPts, (SELECT SUM([TotPts])
    FROM qryRUNTot AS t2
    WHERE t1.Teammate = t2.Teammate AND t1.DateOfAbsence >= t2.DateOfAbsence
  ) AS RSum
FROM qryRUNTot AS t1;

Output from this:
ID   Teammate DateOfAbsence Attendance
                             Credits	TotPts	RSum
1	Ben	1/20/2015	0	1	9.5
2	Ben	1/25/2015	0	1	9.5
3	Ben	4/20/2015	0.5	0.5	9.5
4	Ben	4/21/2015	0	0	9.5
21	Brandon	2/1/2015	0	1	9.5
22	Brandon	2/13/2015	0	0.5	9.5
23	Brandon	3/5/2015	0	0.5	9.5
24	Brandon	3/13/2015	0	1	9.5
25	Brandon	3/14/2015	0	0	9.5
26	Brandon	5/24/2015	0.5	0	9.5
6	Chris	2/15/2015	0	1	9.5
7	Chris	2/16/2015	0	0	9.5
8	Chris	2/28/2015	0	0	9.5
13	Chris	8/22/2015	1.5	0	9.5
14	Don	1/25/2015	0	1	9.5
15	Don	1/26/2015	0	0	9.5
16	Don	3/20/2015	0.5	0.5	9.5
17	Don	5/31/2015	0.5	0.5	9.5
18	Don	6/10/2015	0	0.5	9.5
19	Don	8/20/2015	0.5	0.5	9.5

Query I was pulling data from:
ID	Teammate	DateOfAbsence	prevDateOfAbs	DiffAbs	AbsenceCode	Points	AttendanceCredits	TotPts
1	Ben	1/20/2015			U	1	0	1
2	Ben	1/25/2015	20-Jan-15	5	U	1	0	1
3	Ben	4/20/2015	25-Jan-15	85	U	1	0.5	0.5
4	Ben	4/21/2015	20-Apr-15	1	NON	0	0	0
21	Brandon	2/1/2015			U	1	0	1
22	Brandon	2/13/2015	01-Feb-15	12	U	0.5	0	0.5
23	Brandon	3/5/2015	13-Feb-15	20	U	0.5	0	0.5
24	Brandon	3/13/2015	05-Mar-15	8	U	1	0	1
25	Brandon	3/14/2015	13-Mar-15	1	NON	0	0	0
26	Brandon	5/24/2015	14-Mar-15	71	EM	0	0.5	0
6	Chris	2/15/2015			U	1	0	1
7	Chris	2/16/2015	15-Feb-15	1	NON	0	0	0
8	Chris	2/28/2015	16-Feb-15	12	EM	0	0	0
13	Chris	8/22/2015	28-Feb-15	175	U	0.5	1.5	0
14	Don	1/25/2015			U	1	0	1
15	Don	1/26/2015	25-Jan-15	1	NON	0	0	0
16	Don	3/20/2015	26-Jan-15	53	U	1	0.5	0.5
17	Don	5/31/2015	20-Mar-15	72	U	1	0.5	0.5
18	Don	6/10/2015	31-May-15	10	U	0.5	0	0.5
19	Don	8/20/2015	10-Jun-15	71	U	1	0.5	0.5

[toc] | [prev] | [next] | [standalone]

#11130

From	Ulrich Möller <knobbi38@arcor.de>
Date	2015-09-23 00:39 +0200
Message-ID	<mtsl5n$b5r$1@dont-email.me>
In reply to	#11126

Hi Sara,

Am 22.09.2015 um 20:43 schrieb Sara M:
> Ulrich - I was going to send you my file I couldn't upload it where you sent the link.
>
> I got the point total to sum which I thought I could adjust the code and get the credits to sum up and then simply join the two and get what I need, but for whatever reason, my credits will not sum by teammates - it sums the total for all entries...  what am I doing wrong... I have tried a million different ways...
>
> Can I email you the file or is this easiest?
>
<snip>

please feel free to send me a little test file, because data and the sql 
statement seems to be correct. There must be something else which i 
can't see at the moment.

Ulrich

[toc] | [prev] | [next] | [standalone]

#11132

From	Sara M <sara.mallicoat@genco.com>
Date	2015-09-23 06:11 -0700
Message-ID	<3829b529-67bc-4f83-b2b9-28fbf555ecbe@googlegroups.com>
In reply to	#11130

I can't upload it to that site.  Where can I send the file to?

Thanks!
Sara

[toc] | [prev] | [next] | [standalone]

#11135

From	Ulrich Möller <knobbi38@arcor.de>
Date	2015-09-23 18:23 +0200
Message-ID	<mtujgl$don$1@dont-email.me>
In reply to	#11132

Am 23.09.2015 um 15:11 schrieb Sara M:
> I can't upload it to that site.  Where can I send the file to?
>
> Thanks!
> Sara
To my mail address shown in the news header.

Ulrich

[toc] | [prev] | [next] | [standalone]

#11137

From	Sara M <sara.mallicoat@genco.com>
Date	2015-09-23 09:29 -0700
Message-ID	<9e342ddd-fe3e-40a4-8840-44dc147fc710@googlegroups.com>
In reply to	#11135

On Wednesday, September 23, 2015 at 11:22:41 AM UTC-5, Ulrich Möller wrote:
> Am 23.09.2015 um 15:11 schrieb Sara M:
> > I can't upload it to that site.  Where can I send the file to?
> >
> > Thanks!
> > Sara
> To my mail address shown in the news header.
> 
> Ulrich

Only your name shows up...  your email address isn't listed.  Thanks

[toc] | [prev] | [next] | [standalone]

#11141

From	Ulrich Möller <knobbi38@arcor.de>
Date	2015-09-24 01:00 +0200
Message-ID	<mtvaq2$gs1$1@dont-email.me>
In reply to	#11126

Am 22.09.2015 um 20:43 schrieb Sara M:
> Ulrich - I was going to send you my file I couldn't upload it where you sent the link.
>
> I got the point total to sum which I thought I could adjust the code and get the credits to sum up and then simply join the two and get what I need, but for whatever reason, my credits will not sum by teammates - it sums the total for all entries...  what am I doing wrong... I have tried a million different ways...
>
> Can I email you the file or is this easiest?
>
> Code:
> SELECT t1.ID, t1.Teammate, t1.DateOfAbsence, t1.AttendanceCredits, t1.TotPts, (SELECT SUM([TotPts])
>      FROM qryRUNTot AS t2
>      WHERE t1.Teammate = t2.Teammate AND t1.DateOfAbsence >= t2.DateOfAbsence
>    ) AS RSum
> FROM qryRUNTot AS t1;
>
> Output from this:
> ID   Teammate DateOfAbsence Attendance
>                               Credits	TotPts	RSum
> 1	Ben	1/20/2015	0	1	9.5
> 2	Ben	1/25/2015	0	1	9.5
> 3	Ben	4/20/2015	0.5	0.5	9.5
> 4	Ben	4/21/2015	0	0	9.5
> 21	Brandon	2/1/2015	0	1	9.5
> 22	Brandon	2/13/2015	0	0.5	9.5
> 23	Brandon	3/5/2015	0	0.5	9.5
> 24	Brandon	3/13/2015	0	1	9.5
> 25	Brandon	3/14/2015	0	0	9.5
> 26	Brandon	5/24/2015	0.5	0	9.5
> 6	Chris	2/15/2015	0	1	9.5
> 7	Chris	2/16/2015	0	0	9.5
> 8	Chris	2/28/2015	0	0	9.5
> 13	Chris	8/22/2015	1.5	0	9.5
> 14	Don	1/25/2015	0	1	9.5
> 15	Don	1/26/2015	0	0	9.5
> 16	Don	3/20/2015	0.5	0.5	9.5
> 17	Don	5/31/2015	0.5	0.5	9.5
> 18	Don	6/10/2015	0	0.5	9.5
> 19	Don	8/20/2015	0.5	0.5	9.5
>
> Query I was pulling data from:
> ID	Teammate	DateOfAbsence	prevDateOfAbs	DiffAbs	AbsenceCode	Points	AttendanceCredits	TotPts
> 1	Ben	1/20/2015			U	1	0	1
> 2	Ben	1/25/2015	20-Jan-15	5	U	1	0	1
> 3	Ben	4/20/2015	25-Jan-15	85	U	1	0.5	0.5
> 4	Ben	4/21/2015	20-Apr-15	1	NON	0	0	0
> 21	Brandon	2/1/2015			U	1	0	1
> 22	Brandon	2/13/2015	01-Feb-15	12	U	0.5	0	0.5
> 23	Brandon	3/5/2015	13-Feb-15	20	U	0.5	0	0.5
> 24	Brandon	3/13/2015	05-Mar-15	8	U	1	0	1
> 25	Brandon	3/14/2015	13-Mar-15	1	NON	0	0	0
> 26	Brandon	5/24/2015	14-Mar-15	71	EM	0	0.5	0
> 6	Chris	2/15/2015			U	1	0	1
> 7	Chris	2/16/2015	15-Feb-15	1	NON	0	0	0
> 8	Chris	2/28/2015	16-Feb-15	12	EM	0	0	0
> 13	Chris	8/22/2015	28-Feb-15	175	U	0.5	1.5	0
> 14	Don	1/25/2015			U	1	0	1
> 15	Don	1/26/2015	25-Jan-15	1	NON	0	0	0
> 16	Don	3/20/2015	26-Jan-15	53	U	1	0.5	0.5
> 17	Don	5/31/2015	20-Mar-15	72	U	1	0.5	0.5
> 18	Don	6/10/2015	31-May-15	10	U	0.5	0	0.5
> 19	Don	8/20/2015	10-Jun-15	71	U	1	0.5	0.5
Hi Sara,

if have analyzed your queries and the error is a wrong data type in your 
iif expressions. These expressions e.x.

IIf([DiffAbs] Between 45 And 89,*"0.5"*, ...

returns string values instead of numerical values as expected by the 
dependent calculation and aggregations.
The correct expression would be

IIf([DiffAbs] Between 45 And 89,*0.5*, ...

without the double quotes.

Ulrich

[toc] | [prev] | [standalone]

Page 2 of 2 — ← Prev page 1 [2]

csiph-web

Row numbers in a query to keep track of absences?

Contents

#11102

#11103

#11106

#11107

#11108

#11126

#11130

#11132

#11135

#11137

#11141