Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by blandrp
-
Overflow error from query when criteria added
Turns out there was a record that got a 0 for the #Items somehow - another issue to look into! :( Thanks for the help.- blandrp
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Overflow error from query when criteria added
I've found another interesting twist to my issue. As I stated originally, putting criteria for column 1 without any criteria for column 4 works fine. The issue starts to occur when I have criteria for both columns 1 and 4. I tried to run the query with the criteria for column 4 but without...- blandrp
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Overflow error from query when criteria added
I tried using "<175.00" as well as "<175.01" and neither one works. :( Just in case it might make a difference, this is happening in Access 2003 SP1. Also, I forgot to mention in my first post that the query without the "bad" criteria only brings back 2151 rows so I can't imagine that this...- blandrp
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Overflow error from query when criteria added
I have a fairly simple table containing orders placed (410,412 rows) with the following pertinent columns: Order#: Number (Double) Date: Date/Time #Items: Long Integer OrderAmount: Currency I have a query that is trying to return the orders from the past week with an average item price...- blandrp
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
