Search results

  1. E

    Am I the only one that switches ABBA off?

    When songs like Thank you for the music or Dancing Queen are played, then 80 percent of all listeners between the ages of 9 and 90 are certainly very pleased with such music classics. I'm somewhere in between. If someone complains that they listen to the band's music too often 42 years after...
  2. E

    Mapping VBA Code to show tables affected by VBA

    The following solution from Thomas Koester is also worth a closer look. http://www.accessdependencychecker.com/
  3. E

    Am I the only one that switches ABBA off?

    We have different stations that cater to different tastes in music. So just switch over, perhaps even to your own music from disc or cassette. My current SD card has about 3300 songs that I never hear on the radio.
  4. E

    multiplying values from different rows

    The numbers and the description tell me that these are percentage changes in prices per day. So it's not a running sum, but a running product, which then represents the combined compound interest effect. When using it, I would speculate that one need daily values if one want to display and...
  5. E

    need to make installment plan for 30 months

    For payment plans in queries, I would use the DateAdd function as a guide and create fields in a corresponding base table that serve the arguments of this function. https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/dateadd-function Approach to a query SELECT...
  6. E

    can values in a table be used as criteria to filter a query

    Should it stay that way? SQL is the native language in a database, you can't ignore it permanently. So it would be a good time to invest some effort in knowledge or run away and hand the whole thing over to someone else. The query in #9, supplemented with a filter on the current ID_Employees...
  7. E

    Basement dwellers

    This is a clear self-positioning of a radical and partisan campaigner, which explains everything else.
  8. E

    multiplying values from different rows

    That's no use here, since it's a calculation with recursion - something that Jet-SQL can't do. Of course, it would also be an option to switch to a database management system whose SQL dialect supports recursion.
  9. E

    Basement dwellers

    @Isaac Read the whole sentence, not just a part, and express a complete thought. In other countries one can do something like that.
  10. E

    Basement dwellers

    Is Trump so covered in shame that his fans have to push him into the background and criticize other people? Such maneuvers are very transparent.
  11. E

    multiplying values from different rows

    SELECT D.ID, D.account, D.asof_date, D.security, D.daily_unitized_return, D.expected_result, QueryProduct(D.ID, 1, D.daily_unitized_return, D.account, D.security) AS cumulative_unitized_return INTO NewTable FROM SourceData AS D WHERE Reset_Globals() =...
  12. E

    can values in a table be used as criteria to filter a query

    Inconsistency search: All records from table A that are not in table B. table A ... complete set = all combinations of employees and areas table B ... existing set = your junction table SELECT A.ID_Employees, A.ID_Areas FROM ( SELECT EM.ID_Employees, AR.ID_Areas...
  13. E

    Basement dwellers

    https://www.theguardian.com/us-news/article/2024/aug/20/republican-trump-dnc-speakers
  14. E

    Solved Kill working manually but not in code

    What do Excel processes have to do with a CSV? A CSV is a text file. A file can also be locked if this file is linked; it does not have to be explicitly "opened" in another program. Consequently, you should analyze how this file is used so that you can stop using it and then delete it. So you...
  15. E

    Solved Kill working manually but not in code

    Modules are not executed, only called procedures and functions. It can also simply be possible that a specific line is not accessed => not called, bypassed due to a logical switch or something else.
  16. E

    Extracting varying length string between two characters

    There are also different opinions. If someone claims something that is not happening, based on a clear example, it could be reduced to the fact that he himself is babbling or doing something else. In both cases, such statements should not be used to generalize, but should be characterized as a...
  17. E

    Extracting varying length string between two characters

    When statements and conclusions contradict each other significantly, one should think twice ...
  18. E

    Extracting varying length string between two characters

    So what's wrong with @Josef P.'s example? After all, it's complete in the presentation, and it's been downloaded nine times so far.
  19. E

    Extracting varying length string between two characters

    That alone is certainly not enough. Keyword lazy loading: Often only the first records are displayed, while later records are still being calculated. To ensure that ALL records have been recorded, you have to go to the end of the recordset. You can add your tests with measurements to the...
  20. E

    Extracting varying length string between two characters

    If two people test, there will be three different results. Therefore, it is always relevant to show exactly how the test is carried out.
Back
Top Bottom