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

    Correlated Subquery only pulls matching records

    Hello, I am trying to build a subquery/correlated subquery in Brio, where it returns all the parent records, with the child records only matching based on a specific limit. I cannot do this in the standard query based on the relationships. I have tried both correlated subquery and a regular...
  2. szumerspirit

    VBA code running perfectly one one PC, not on Others

    I have compiled a VB code, borrowing some, adding some. It's intended purpose is to get information about all files in a directory/disk. Originally I used the the msoFileTypeAll, until I read that it did not always pick up .zip's as files vs folders. I added a new section to pick up zip files...
  3. szumerspirit

    ODBC Linked Table not showing all Fields

    I have a table linked via an ODBC connection to an Access 2003 database. There are many other tables linked thru the same dsn connection from the same datamart with no problems. However, when linking this table, it only shows half of the field list. If I look at it thru a different GUI I can...
  4. szumerspirit

    Summing total of Overlapping Dates without duplication

    Hello, I am trying to create a SQL query or VBA code in Access 2003 which will allow me to find multiple records for an order, sum the interval between the start and end dates of those records. Where overlapping dates exist, it would sum the total days from the earliest day to the latest day...
  5. szumerspirit

    Summing total of Overlapping Dates without duplication of days

    Hello, I am trying to create a SQL query or VBA code in Access 2003 which will allow me to find multiple records for an order, sum the interval between the start and end dates of those records. Where overlapping dates exist, it would sum the total days from the earliest day to the latest day...

Part and Inventory Search

Back
Top