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 derfloh 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: eHigh
  • Order by date
  1. eHigh

    Min/Max Time of data in different format

    Modified if statement to handle problem above, but stuck on the problem when TIME remains the same but Route changes. For example, the third line below creates two entries and I only want one. Any assistance would be appreciated. Thanks. BLOCK TIME ALT_SORT Route 007-92...
  2. eHigh

    Min/Max Time of data in different format

    What if the Route does not change, but the Block changes? For example, the data below changes from Block 7-92 to 7-93 but the Route remains 7. How could I adjust the "basBlockMinMax" function to handle this? BLOCK TIME ALT_SORT Route 007-92 18:21 65760 27 007-92 18:38 65760 27 007-92...
  3. eHigh

    Run Make-Table Action query

    This worked great! Thanks!
  4. eHigh

    Run Make-Table Action query

    In table design view I set the data type to date/time. But when running the make-table action query it changes the "date/time" data type to "text" data type. When running the make-table action query can I force it keep the "date/time" data type?
  5. eHigh

    Min/Max Time of data in different format

    The "basBlockMinMax" function works great. Thank you!
  6. eHigh

    Min/Max Time of data in different format

    I have several blocks of data in the format below: This is the datasheet view of a MS Access table. Block Time Route 004-02 06:29 4 004-02 06:39 4 004-02 06:43 4 004-02 06:49 4 004-02 06:53 4 004-02 07:00 18 004-02 07:07 18 004-02 07:12 18 004-02 07:16 18 004-02 07:19 18 004-02 07:24 18 004-02...
  7. eHigh

    transpose a file and import into MS Access from Excel

    How can I transpose the file below? Currently the file is in this format in Excel: Employer Contact Misc (Sales, Employee #) 3-D IMAGING DEVELOPMENT CONTACT: RODNEY WARNER, OWNER NAICS: 2372 12301 N LAMAR BLVD PHONE: (512)837-6644 SALES: $2.5 Million - $5 Million AUSTIN, TX 78753-1314 FAX...
  8. eHigh

    Updating table using combo box

    Thanks! You guys and this website are a great resource!
  9. eHigh

    Updating table using combo box

    Users would like to select from a combo box and if their selection is not there they would like to enter the data into the combo box and update the undelying record source for future selections. Is there a simple way to do this? Thanks.
  10. eHigh

    How can I tell if a user edits a field/column in a table

    Thanks. I thought I would have to force users to go through a form, but wasn't sure.
  11. eHigh

    How can I tell if a user edits a field/column in a table

    How can I tell if a user opens a table in datasheet view and edits a field/column in the table? I would like to write to a log table anytime a user edits a table field. The logFunction below writes to the log table using CurrentUser. For example: If table opened logFunction "testTable has...
  12. eHigh

    Computing Percentiles in MS Access

    When I used the following SQL statement I get the error below: SELECT Count([2002perCaps].ID) AS NumberOfLibraries, Min([2002perCaps].percap) AS LOW, Max([2002perCaps].percap) AS HIGH, Avg([2002perCaps].percap) AS AVERAGE, basPercentile(0.25, [2002perCaps].percap) AS 25th_Percentile FROM...
  13. eHigh

    Computing Percentiles in MS Access

    Michael, Thanks for the feedback. When I call the 'basPercentile' function I get an error. To get the 25th percentile I use the call below: basPercentile(0.25, FieldName) Is there something wrong with my call statement? Also, what if I want to set a reference to the Excel Library and use...
  14. eHigh

    Computing Percentiles in MS Access

    How could I compute the 25th, 50th, and 75th percentiles for the values below in MS Access? 17.2068311195446 46.2558502340094 4.99548328816621 15.6774955699941 9.82629107981221 40.3058419243986 18.5503711558855 69.0640279394645 5.09231685527099 19.3273542600897 11.422159887798 29.8877968877969...
  15. eHigh

    get all mailing addresses with no value for shipping address

    I meant: How can I get all the mailing addresses even though there are null or empty shipping address? Thanks
  16. eHigh

    get all mailing addresses with no value for shipping address

    In the query below, I'm trying to get the mail address and the shipping address. Both addresses are in the ADDRESS table. However some Organizations have mail addresses but not shipping addresses. I would like to get all the mailing addresses even though there is no matching shipping address...
    • eHigh
    • Thread
    • Replies: 2
    • Forum: MySQL
  17. eHigh

    parse a string

    Thanks Skip for all your help!!! I finally got my brain to focus on mult-dimensional arrays and with some modifications to the dateStr functions (i.e., empty strings, comma delimited strings, etc.) the data is looking pretty good now. Thanks again!
  18. eHigh

    parse a string

    Modified code to this point but still struggling. Sub CombineRegHours2() Dim db As DAO.Database Dim rec As DAO.Recordset Dim strSQL As String Dim dateStr As String Dim regHour(7) Dim i As Integer strSQL = "SELECT reg_Sun, reg_Mon, reg_Tue, reg_Wed, &quot...
  19. eHigh

    parse a string

    This is the code I've developed so far and also a list of about the first 20 records in the table. Sub CombineRegHours() Dim db As DAO.Database Dim rec As DAO.Recordset Dim strSQL As String Dim sun, mon, tue, wed, thu, fri, sat As String strSQL = "SELECT reg_Sun...
  20. eHigh

    parse a string

    Thanks!!! This function works The function above worked for data that's formatted correctly. But if I could extract the data directly from the table this would provide a much cleaner solution. What if the data is contained in a table with fields for each day as shown below: Sun Mon...

Part and Inventory Search

Back
Top