ebs17's latest activity

  • E
    ebs17 replied to the thread Query return max value.
    Since this will probably take longer, I have written down my thoughts in the attached demo. It will be shown: 1) how I imagine a useful...
  • E
    ebs17 replied to the thread Correlation between two records of the same table.
    SELECT P1.ProductName AS Product1, P2.ProductName AS Product2, P1.Size - P2.Size AS Diff FROM tblProducts AS P1...
  • E
    ebs17 replied to the thread Query return max value.
    A real example should be based on a real database. So upload an example database with some representative records here, including the...
  • E
    ebs17 replied to the thread Query return max value.
    Is the table an export/import or a direct link to SAP? Furthermore, if you have a view, a query or a report in front of you, it also...
  • E
    ebs17 replied to the thread Query return max value.
    Then you can forget about a reasonable query. SQL works row-oriented, not column-oriented. But with VBA and the appropriate skills you...
  • E
    ebs17 replied to the thread Query return max value.
    Your table does not correspond to the expected table design for a database. http://www.allenbrowne.com/casu-23.html The first correct...
  • E
    ebs17 replied to the thread A counting problem.
    SELECT Name, Database FROM MSysObjects WHERE Database > "" This allows you to determine the linked tables and the associated backend...
  • E
    ebs17 replied to the thread How can I delete Duplicate Records from a table.
    This is what I call an exclusive opinion. I can only shake my head at what some people think. For those who can read: My suggestion...
  • E
    ebs17 replied to the thread How to select and also exclude criteria from same field.
    You can also create a pivot table = crosstab query directly in Access. One of the above queries saved as Qx: TRANSFORM MIN(M.Profit)...
  • E
    ebs17 replied to the thread How to select and also exclude criteria from same field.
    SELECT M1.Supplier, M1.SUP_ID FROM mytable AS M1 WHERE M1.Product = "Lemonade" AND NOT EXISTS (...
  • E
    ebs17 replied to the thread How can I delete Duplicate Records from a table.
    That's not OK. A query that produces unwanted duplicates should be reworded. This is about a table that contains duplicates, for...
  • E
    ebs17 replied to the thread delete duplicates.
    A query is mass data processing - all at once. Therefore, you immediately need a secure and reliable attribute for a first or second...
  • E
    ebs17 replied to the thread delete duplicates.
    Who is the question for? EXISTS is part of the ANSI89 language set that Jet-SQL (=Access-SQL) uses. So you can use it, and I haven't...
  • E
    ebs17 replied to the thread delete duplicates.
    I'm very sure of that.
  • E
    ebs17 replied to the thread delete duplicates.
    https://www.access-programmers.co.uk/forums/threads/how-can-i-delete-duplicate-records-from-a-table.331088/#post-1919658
Show older items
Top Bottom