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
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...
May 14, 2024
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.
May 13, 2024
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.
May 13, 2024
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...
May 13, 2024
E
ebs17
replied to the thread
Connect different databases
.
However, with the UNION query you subsequently lose all index usage. A real database regularly comes with a lot of data, and you need...
May 11, 2024
E
ebs17
replied to the thread
Connect different databases
.
This is a problem of our own making. If necessary, you should move the attachments to additional backends, but not the actual data.
May 10, 2024
E
ebs17
replied to the thread
How can I delete Duplicate Records from a table
.
If you only want to delete parts of them, you need an attribute that allows you to distinguish between the records and can therefore be...
May 10, 2024
E
ebs17
replied to the thread
Linked table date error trapping
.
You could show these examples.
May 10, 2024
E
ebs17
replied to the thread
Linked table date error trapping
.
In the import specification, change the data type for this column to text. Text can initially record everything. Then, to link the text...
May 10, 2024
E
ebs17
replied to the thread
Solved
Stop Users from adding on second subform if #1 is not filled
.
I think you have to approach it completely differently. What dependencies are there between specialty and specialist? Show the database...
May 9, 2024
E
ebs17
replied to the thread
Solved
Need some advice on a Total query
.
Passing parameters to a query - variants...
May 9, 2024
E
ebs17
replied to the thread
Negative values are seen as positive
.
Expr1="Yes" What does this have to do with positive or negative numbers?
May 8, 2024
E
ebs17
replied to the thread
Date on query
.
WHERE DateField > 0 In contrast to the suggestion with NOT, index use is possible here, and index use should always be kept as open as...
May 7, 2024
E
ebs17
replied to the thread
Solved
Tool for combining PDFs
.
In order to present something as the "best solution", requirements from a development environment such as Access should be met. A key...
May 7, 2024
E
ebs17
replied to the thread
Updating MakeTable Queries for a new version of the database
.
You always have to react to unknown changes, regardless of whether you use an annual copy or an entire database. Where is there a...
May 4, 2024
Home
Members
Top
Bottom