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: *

  • Users: arb4
  • Order by date
  1. arb4

    Access 2002 SUM Function Datatype Error

    I am writing an SQL Pass-Through Query in Access 2002 to retrieve Data from an Oracle database. Everything works OK except my aggregate SUM function is not returning Decimal data -- looks like it is truncating the amounts. I've seen a thread in here (thread68-100697) that recommends reverting...
  2. arb4

    Excel-Need to Create Query for a few static items in Lrg. Spreadsheet

    Are your 40 items located in just one of the 65 columns, or are you looking for them anywhere in the spreadsheet?
  3. arb4

    Import Excel Cells as yes no into access database

    Seems like it might be simpler to manipulate the data while in Excel rather than in Access. Not sure what your flexibility is with the spreadsheet, but an easy solution would be to convert the "dots" to "TRUE" or "YES" or the number 1 (basically some integer other...
  4. arb4

    [ACCESS]

    I'm sure there's a more elegant way to address this problem, but if used two queries you could retrieve the info you want. In the first query link the two tables by Book # (simple join) and retrieve the Book# and Cust# and limit to the Cust# you're interested in. Then, in the second query link...
  5. arb4

    Combining Data

    Probably the most helpful tool in Excel for combining this type of data is a Pivot Table. Make sure your data has column headers, then highlight the data (including headers) and select PivotTables from the Data menu. Depending on what version of Excel you're running you may have a slightly...

Part and Inventory Search

Back
Top