data type mismatch

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I am getting this error msg when i try to sum market values in a report. It
is very strange as i understand the query has the market values data type as
Fixed.
Can anyone help me get this over the line?
Thanks
George
 
George,
You get an error message, but don't indicate what it is.
And, you give us no information about your report, your fields or your calculations.
(what you have now vs. what you want)
 
Hi Al,
I guess i shouldn't assume everybody knows what i am talking about.
What i have is a list of market values for stocks in a report, and what i am
trying to do is add a text box to the header that sums all these market
values.
When i try to do a sum i get the "data type mismatch error in criteria
expression".
i am stating =Sum([Market Value]) in the control source and the Format =
Currency. I am lost for a reason this error is coming up. In the query that
this report sources the market value format is set to Fixed. Please help.
Thanks
George
 
When you look at [Market Value] in the query, is it left or right aligned?
If it is left aligned, then it is assumed to be text which can't be summed
without converting it to a numeric value.

--
Duane Hookom
MS Access MVP

George said:
Hi Al,
I guess i shouldn't assume everybody knows what i am talking about.
What i have is a list of market values for stocks in a report, and what i
am
trying to do is add a text box to the header that sums all these market
values.
When i try to do a sum i get the "data type mismatch error in criteria
expression".
i am stating =Sum([Market Value]) in the control source and the Format =
Currency. I am lost for a reason this error is coming up. In the query
that
this report sources the market value format is set to Fixed. Please help.
Thanks
George


Al Campagna said:
George,
You get an error message, but don't indicate what it is.
And, you give us no information about your report, your fields or
your calculations.
(what you have now vs. what you want)
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
Click to expand...
Click to expand...
 
Hi Duane,
It looks to be right aligned. Is there a right align button like in excel to
be sure?
George

Duane Hookom said:
When you look at [Market Value] in the query, is it left or right aligned?
If it is left aligned, then it is assumed to be text which can't be summed
without converting it to a numeric value.

--
Duane Hookom
MS Access MVP

George said:
Hi Al,
I guess i shouldn't assume everybody knows what i am talking about.
What i have is a list of market values for stocks in a report, and what i
am
trying to do is add a text box to the header that sums all these market
values.
When i try to do a sum i get the "data type mismatch error in criteria
expression".
i am stating =Sum([Market Value]) in the control source and the Format =
Currency. I am lost for a reason this error is coming up. In the query
that
this report sources the market value format is set to Fixed. Please help.
Thanks
George


Al Campagna said:
George,
You get an error message, but don't indicate what it is.
And, you give us no information about your report, your fields or
your calculations.
(what you have now vs. what you want)
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Hi,
I am getting this error msg when i try to sum market values in a
report. It
is very strange as i understand the query has the market values data
type as
Fixed.
Can anyone help me get this over the line?
Thanks
George
Click to expand...
Click to expand...
Click to expand...
 
You don't want to perform any formatting in the query. Use the format
property of your controls on forms and reports to do most of you formatting.

What is the SQL view of your report's record source?

--
Duane Hookom
MS Access MVP

George said:
Hi Duane,
It looks to be right aligned. Is there a right align button like in excel
to
be sure?
George

Duane Hookom said:
When you look at [Market Value] in the query, is it left or right
aligned?
If it is left aligned, then it is assumed to be text which can't be
summed
without converting it to a numeric value.

--
Duane Hookom
MS Access MVP

George said:
Hi Al,
I guess i shouldn't assume everybody knows what i am talking about.
What i have is a list of market values for stocks in a report, and what
i
am
trying to do is add a text box to the header that sums all these market
values.
When i try to do a sum i get the "data type mismatch error in criteria
expression".
i am stating =Sum([Market Value]) in the control source and the Format
=
Currency. I am lost for a reason this error is coming up. In the query
that
this report sources the market value format is set to Fixed. Please
help.
Thanks
George


:

George,
You get an error message, but don't indicate what it is.
And, you give us no information about your report, your fields or
your calculations.
(what you have now vs. what you want)
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Hi,
I am getting this error msg when i try to sum market values in a
report. It
is very strange as i understand the query has the market values data
type as
Fixed.
Can anyone help me get this over the line?
Thanks
George
Click to expand...
Click to expand...
Click to expand...
 
Duane,
The control source is the query it is run off.
If i try to change the format in the report for the [Market Value], i.e use
the drop down it comes up blank, it does not give me the option to use fixed,
standard or currency. This looks like this is where my problem is? Any
suggestions?
George

Duane Hookom said:
You don't want to perform any formatting in the query. Use the format
property of your controls on forms and reports to do most of you formatting.

What is the SQL view of your report's record source?

--
Duane Hookom
MS Access MVP

George said:
Hi Duane,
It looks to be right aligned. Is there a right align button like in excel
to
be sure?
George

Duane Hookom said:
When you look at [Market Value] in the query, is it left or right
aligned?
If it is left aligned, then it is assumed to be text which can't be
summed
without converting it to a numeric value.

--
Duane Hookom
MS Access MVP

Hi Al,
I guess i shouldn't assume everybody knows what i am talking about.
What i have is a list of market values for stocks in a report, and what
i
am
trying to do is add a text box to the header that sums all these market
values.
When i try to do a sum i get the "data type mismatch error in criteria
expression".
i am stating =Sum([Market Value]) in the control source and the Format
=
Currency. I am lost for a reason this error is coming up. In the query
that
this report sources the market value format is set to Fixed. Please
help.
Thanks
George


:

George,
You get an error message, but don't indicate what it is.
And, you give us no information about your report, your fields or
your calculations.
(what you have now vs. what you want)
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Hi,
I am getting this error msg when i try to sum market values in a
report. It
is very strange as i understand the query has the market values data
type as
Fixed.
Can anyone help me get this over the line?
Thanks
George
Click to expand...
Click to expand...
Click to expand...
 
You seem to have ignored my question:
"What is the SQL view of your report's record source?"

You stated earlier "market value format is set to Fixed". Where did you do
this?
--
Duane Hookom
MS Access MVP

George said:
Duane,
The control source is the query it is run off.
If i try to change the format in the report for the [Market Value], i.e
use
the drop down it comes up blank, it does not give me the option to use
fixed,
standard or currency. This looks like this is where my problem is? Any
suggestions?
George

Duane Hookom said:
You don't want to perform any formatting in the query. Use the format
property of your controls on forms and reports to do most of you
formatting.

What is the SQL view of your report's record source?

--
Duane Hookom
MS Access MVP

George said:
Hi Duane,
It looks to be right aligned. Is there a right align button like in
excel
to
be sure?
George

:

When you look at [Market Value] in the query, is it left or right
aligned?
If it is left aligned, then it is assumed to be text which can't be
summed
without converting it to a numeric value.

--
Duane Hookom
MS Access MVP

Hi Al,
I guess i shouldn't assume everybody knows what i am talking about.
What i have is a list of market values for stocks in a report, and
what
i
am
trying to do is add a text box to the header that sums all these
market
values.
When i try to do a sum i get the "data type mismatch error in
criteria
expression".
i am stating =Sum([Market Value]) in the control source and the
Format
=
Currency. I am lost for a reason this error is coming up. In the
query
that
this report sources the market value format is set to Fixed. Please
help.
Thanks
George


:

George,
You get an error message, but don't indicate what it is.
And, you give us no information about your report, your fields
or
your calculations.
(what you have now vs. what you want)
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Hi,
I am getting this error msg when i try to sum market values in a
report. It
is very strange as i understand the query has the market values
data
type as
Fixed.
Can anyone help me get this over the line?
Thanks
George
Click to expand...
Click to expand...
Click to expand...
 
To view the SQL, open the query and click View > SQL. Copy what you see,
and post it here. That's what Duane is asking you to do.

George said:
Duane,
The control source is the query it is run off.
If i try to change the format in the report for the [Market Value], i.e
use
the drop down it comes up blank, it does not give me the option to use
fixed,
standard or currency. This looks like this is where my problem is? Any
suggestions?
George

Duane Hookom said:
You don't want to perform any formatting in the query. Use the format
property of your controls on forms and reports to do most of you
formatting.

What is the SQL view of your report's record source?

--
Duane Hookom
MS Access MVP

George said:
Hi Duane,
It looks to be right aligned. Is there a right align button like in
excel
to
be sure?
George

:

When you look at [Market Value] in the query, is it left or right
aligned?
If it is left aligned, then it is assumed to be text which can't be
summed
without converting it to a numeric value.

--
Duane Hookom
MS Access MVP

Hi Al,
I guess i shouldn't assume everybody knows what i am talking about.
What i have is a list of market values for stocks in a report, and
what
i
am
trying to do is add a text box to the header that sums all these
market
values.
When i try to do a sum i get the "data type mismatch error in
criteria
expression".
i am stating =Sum([Market Value]) in the control source and the
Format
=
Currency. I am lost for a reason this error is coming up. In the
query
that
this report sources the market value format is set to Fixed. Please
help.
Thanks
George


:

George,
You get an error message, but don't indicate what it is.
And, you give us no information about your report, your fields
or
your calculations.
(what you have now vs. what you want)
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Hi,
I am getting this error msg when i try to sum market values in a
report. It
is very strange as i understand the query has the market values
data
type as
Fixed.
Can anyone help me get this over the line?
Thanks
George
Click to expand...
Click to expand...
Click to expand...
 
Hi all,
Thanks for the help,
It was a wild goose chase. The goose being me. I found a question mark (?)
in my data and this was the error.
Regards
George

BruceM said:
To view the SQL, open the query and click View > SQL. Copy what you see,
and post it here. That's what Duane is asking you to do.

George said:
Duane,
The control source is the query it is run off.
If i try to change the format in the report for the [Market Value], i.e
use
the drop down it comes up blank, it does not give me the option to use
fixed,
standard or currency. This looks like this is where my problem is? Any
suggestions?
George

Duane Hookom said:
You don't want to perform any formatting in the query. Use the format
property of your controls on forms and reports to do most of you
formatting.

What is the SQL view of your report's record source?

--
Duane Hookom
MS Access MVP

Hi Duane,
It looks to be right aligned. Is there a right align button like in
excel
to
be sure?
George

:

When you look at [Market Value] in the query, is it left or right
aligned?
If it is left aligned, then it is assumed to be text which can't be
summed
without converting it to a numeric value.

--
Duane Hookom
MS Access MVP

Hi Al,
I guess i shouldn't assume everybody knows what i am talking about.
What i have is a list of market values for stocks in a report, and
what
i
am
trying to do is add a text box to the header that sums all these
market
values.
When i try to do a sum i get the "data type mismatch error in
criteria
expression".
i am stating =Sum([Market Value]) in the control source and the
Format
=
Currency. I am lost for a reason this error is coming up. In the
query
that
this report sources the market value format is set to Fixed. Please
help.
Thanks
George


:

George,
You get an error message, but don't indicate what it is.
And, you give us no information about your report, your fields
or
your calculations.
(what you have now vs. what you want)
--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Hi,
I am getting this error msg when i try to sum market values in a
report. It
is very strange as i understand the query has the market values
data
type as
Fixed.
Can anyone help me get this over the line?
Thanks
George
Click to expand...
Click to expand...
Click to expand...
 
Back
Top