• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 330
  • Last Modified:

Data type mismatch

I am trying to run the following query. I keep getting "Data Type Mismatch"

Any ideas? Thanks!

SELECT Sum(qryStatsIndividual.MessagesRecorded) AS SumOfMessagesRecorded, Sum(qryStatsIndividual.TotalNewClients) AS SumOfTotalNewClients, Sum(qryStatsIndividual.BookedTrue) AS SumOfBookedTrue, Sum(qryStatsIndividual.TalkedTo) AS SumOfTalkedTo, Sum(qryStatsIndividual.PercentBooked) AS SumOfPercentBooked, Sum(qryStatsIndividual.FiveMinCallBack) AS SumOfFiveMinCallBack, Sum(qryStatsIndividual.PercentinFive) AS SumOfPercentinFive, "ADAY" AS DateSpec, DateValue(Nz([qryStatsIndividual].[DateField],#1/1/1950#)) AS Expr1
FROM qryStatsIndividual
GROUP BY "ADAY", DateValue(Nz([qryStatsIndividual].[DateField],#1/1/1950#))
HAVING (((DateValue(Nz([qryStatsIndividual].[DateField],#1/1/1950#)))=DateValue(Now())));

Open in new window

0
cansevin
Asked:
cansevin
1 Solution
 
pdebaetsCommented:
I wonder if you might be trying to sum a text field here

Sum(qryStatsIndividual.TalkedTo) AS SumOfTalkedTo

?

If that's not it, make a copy of your query, then remove one column at a time until you find the column that is causing the problem. then check the data type of the field in that column.
0
 
aikimarkCommented:
my guess would be
DateValue(Nz([qryStatsIndividual].[DateField],#1/1/1950#))

Open in new window

DateValue() expects a string parameter, but you are passing a date data type.
0
 
IrogSintaCommented:
Perhaps the problem lies in the query called qryStatsIndividual.  Can you post the SQL of that one?
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now