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

    Select Query producing 'overflow' error

    Problem solved. Some of the data used in the query was invalid. There was division by zero.
  2. ebnemik

    Select Query producing 'overflow' error

    Hello! I have a select query, which is giving me an 'overflow' error, but I have no idea where/ what is causing this to occur. Any ideas or thoughts are appreciated. I know this is very general, but it might have to do with some calculations. On their own they are working properly. thanks...
  3. ebnemik

    Stress testing an Access application

    I was wondering if it is possible to impose a stress test on an existing Access 2000 application. I would like to know if anyone knows if there is a tool avaialble or how I would going about seeing if my databases are going to be able to handle the added records. What about possible performance...
  4. ebnemik

    Join not returning correct number of rows

    jrbarnett, Thanks for the reply. I dont think these tables have referential integrity enforced, but I do not believe I am getting a cartesian join. I have included my query: I want to get the number of records that are not in one of the queries, so I want to combine them where they are the...
  5. ebnemik

    Join not returning correct number of rows

    I am trying to write a query to select 3 fields from one query & 2 other fields from another query. When I attempt to run this and I join on the three fields from the first query to the 2nd I get duplicate rows. Meaning, without the 2 fields form the 2nd query I get X amount of rows, but since...

Part and Inventory Search

Back
Top