Query pains please help

[Guest]

Good day, I am in serious need of help here. I have a query that has
calculated expressions and a main field called RecordNumber, what I am trying
to do is count the record number but everytime I open the totals field and
change that field to count I get the following message:

Warning messages says: You tried to execute a query that does not include
the specified expression
'[Expr2]+[Expr3]+[Expr4]+[Expr5]+[Expr6]+[Expr7]+[Expr20]+[Expr21]+[Expr22]+[Expr23]+[Expr24]+[Expr25].

The expressions that I have in the query are as follows:

Expr52: [Expr37]+[Expr40]+[Expr43]+[Expr46]+[Expr49] (this adds up total
points)

Expr53: [Expr38]+[Expr41]+[Expr44]+[Expr47]+[Expr50] (this adds up total
possible points)

Expr54: Expr54: [Expr52]/[Expr53] (this divides total points by the possible
points to give %

The above expressions Expr52 and Expr53 sums points vertically (up and down).

Please let me know if you need more information. Thank you so much for your
help in advance.

 

[Guest]

Well, Expr52 and expr 53 doesn't exist yet when you run expr54.

So, put expr52 and expr 53 in query1, then run expr54 in query2 stacking off
of query1.

In short, you can't calculate expr54 until expr52 and expr53 has been
calculated.

If you must do it within the same query, then you need to do expr54 as:

expr54:
([Expr37]+[Expr40]+[Expr43]+[Expr46]+[Expr49])/([Expr38]+[Expr41]+[Expr44]+[Expr47]+[Expr50])

 

[Guest]

DCPan thank you so much for your help it looks like that solve part of my
problem. I work for a call center and we track our customer service reps
calls we call it monitoring. Anway in this report I am working on I need to
be able to select a date that monitoring and scoring was done. I used this in
my criteria: Between[type the begining date01/01/07)]And[Type the ending
date: (12/31/07)] the report works fine if I am running dates from say
01/01/07 to 01/03/07, however when I expand the dates to say end 01/15/07 I
get the following Warning message: The expression is typed incorrectly, or is
too complex to be evaulated. For example, a numeric expression may contain
too many complicated elements. Try simplying the expression by assigning
parts of the expression to variables. Part 2: is lets say John Doe have four
monitors 1 for 01/01/07, 1 for 01/05/07, 1 for 01/07/07, 1 for 01/10/07. In
the totals on the query I put count records but it comes back with the
warning message: You tried to execute a query that does not include

the specified expression
'[Expr2]+[Expr3]+[Expr4]+[Expr5]+[Expr6]+[Expr7]+[Expr20]+[Expr21]+[Expr22]+[Expr23]+[Expr24]+[Expr25].

Thank you DCPan for all your help.

Well, Expr52 and expr 53 doesn't exist yet when you run expr54.

So, put expr52 and expr 53 in query1, then run expr54 in query2 stacking off
of query1.

In short, you can't calculate expr54 until expr52 and expr53 has been
calculated.

If you must do it within the same query, then you need to do expr54 as:

expr54:
([Expr37]+[Expr40]+[Expr43]+[Expr46]+[Expr49])/([Expr38]+[Expr41]+[Expr44]+[Expr47]+[Expr50])

Good day, I am in serious need of help here. I have a query that has
calculated expressions and a main field called RecordNumber, what I am trying
to do is count the record number but everytime I open the totals field and
change that field to count I get the following message:

Warning messages says: You tried to execute a query that does not include
the specified expression
'[Expr2]+[Expr3]+[Expr4]+[Expr5]+[Expr6]+[Expr7]+[Expr20]+[Expr21]+[Expr22]+[Expr23]+[Expr24]+[Expr25].

The expressions that I have in the query are as follows:

Expr52: [Expr37]+[Expr40]+[Expr43]+[Expr46]+[Expr49] (this adds up total
points)

Expr53: [Expr38]+[Expr41]+[Expr44]+[Expr47]+[Expr50] (this adds up total
possible points)

Expr54: Expr54: [Expr52]/[Expr53] (this divides total points by the possible
points to give %

The above expressions Expr52 and Expr53 sums points vertically (up and down).

Please let me know if you need more information. Thank you so much for your
help in advance.