Menu
Home
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
Current visitors
New profile posts
Search profile posts
Menu
Log in
Register
Home
Members
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
ebs17's latest activity
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...
Today at 7:24 AM
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...
Today at 6:47 AM
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...
Today at 6:35 AM
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...
Today at 4:32 AM
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)...
Yesterday at 9:22 PM
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 (...
Yesterday at 8:45 PM
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...
Yesterday at 8:27 PM
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...
Yesterday at 5:51 PM
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...
Yesterday at 5:43 PM
E
ebs17
replied to the thread
delete duplicates
.
I'm very sure of that.
Yesterday at 5:17 PM
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
Yesterday at 4:04 PM
E
ebs17
replied to the thread
How can I delete Duplicate Records from a table
.
But you should also be able to do a delete query on a table, it's not a big challenge. If you always need a new table to display...
Yesterday at 10:16 AM
E
ebs17
replied to the thread
Solved
Exclude Duplicate Records from a Query
.
A concrete proposal can only be created based on a specific specification. The SQL statement is a fairly comprehensive definition.
Monday at 10:13 AM
E
ebs17
replied to the thread
Solved
Exclude Duplicate Records from a Query
.
With a unique index on the field or field combination that contains the duplicates, you can safely prevent unwanted duplicates in the table.
Monday at 10:09 AM
E
ebs17
replied to the thread
Solved
Exclude Duplicate Records from a Query
.
SQL IS easy. When telling stories about queries, it's helpful to show the SQL statement itself. You should also take into account that...
Monday at 9:46 AM
Home
Members
Top
Bottom