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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 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.
  2. blandrp

    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...
  3. blandrp

    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...
  4. blandrp

    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...

Part and Inventory Search

Back
Top