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

    Cannot add ODBC Data Source

    Yes, I am the administrator. Apparently, reinstalling my Oracle software solved the problem. Thank you very much for your response, nonetheless. :) missjen
  2. missjen

    Cannot add ODBC Data Source

    Hi! I have recently upgraded from Win98 to Win2000 OS. Prior to the upgrade, I had successfully added new system data sources through the ODBC Data Source Administrator (for connecting to remote tables within my local MS Access program). Now, after the upgrade, as I attempt to add a new...
  3. missjen

    How do I "Refresh" Data Automatically?

    I have a combo text box on a (datasheet view) sub-form that selects its data from a field in a table that is separate from the underlying sub-form record source. I have the sub-form control's "Limit to List" property set to "No". When the user discovers the value they are...
  4. missjen

    Counting Unique Records Within 24 hours

    Michael, Thanks for you're feedback. However, I think I structured my question incorrectly. I only want to find ONE (the first occurence) transaction per PRODUCT_ID (1 unique ID) per 24 hour period (from 12:00 a.m. to 11:59 p.m), and exclude other instances of PRODUCT_ID transactions during...
  5. missjen

    Counting Unique Records Within 24 hours

    Q: There a PRODUCT table with a primary PRODUCT_ID key. There is a TRANSACTION table that records PRODUCT purchases. The TRANSACTION table contains duplicate PRODUCT_ID fields and and a TIMESTAMP date field that records the date of the transaction. How can I construct a query/expression to...
  6. missjen

    Only the month(char) and year from the date

    Q: There a PRODUCT table with a primary PRODUCT_ID key. There is a TRANSACTION table that records PRODUCT purchases. The TRANSACTION table contains duplicate PRODUCT_ID fields and and a TIMESTAMP date field that records the date of the transaction. How can I construct a query/expression to...

Part and Inventory Search

Back
Top