467,166 Members | 1,067 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,166 developers. It's quick & easy.

please help: overflow problem in query result using double precision fields from underlying table

Hi,

In a table I have two numeric fields (e.g. FieldA and FieldB). Both fields
have double precicion (field size "double"), Format "Fixed" and Decimal
places "3" since I want to calculate with at least 3 digits precision (e.g.
values might show as 0.123).

In a select query, I divide FieldA by FieldB. All results show properly.

Then I want to display all records that show values above 0.5. To do so, I
enter
query criteria: >0.5

When I run the query, I get the message "Overflow". When I press ok, I get
the message again, when I press ok for the second time, the query result
shows #Name? in all fields.

Anyone who can help me with this?

Thanks a lot!

Maarten

Jun 9 '07 #1
  • viewed: 1854
Share:
1 Reply
On Jun 9, 6:19 pm, "Maarten van der Cammen"
<maartenvandercam...@yahoo.comwrote:
Hi,

In a table I have two numeric fields (e.g. FieldA and FieldB). Both fields
have double precicion (field size "double"), Format "Fixed" and Decimal
places "3" since I want to calculate with at least 3 digits precision (e.g.
values might show as 0.123).

In a select query, I divide FieldA by FieldB. All results show properly.
the where clause for the query should be:
where (FieldA/FieldB) .5
is that what you have?

Cheers,
Barry
Then I want to display all records that show values above 0.5. To do so, I
enter
query criteria: >0.5

When I run the query, I get the message "Overflow". When I press ok, I get
the message again, when I press ok for the second time, the query result
shows #Name? in all fields.

Anyone who can help me with this?

Thanks a lot!

Maarten

Jun 10 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Martin | last post: by
2 posts views Thread by steve.turner@gmail.com | last post: by
3 posts views Thread by cover | last post: by
6 posts views Thread by tizmagik@gmail.com | last post: by
47 posts views Thread by Jo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.