Search results

If you want to read a text in German - here are some thoughts I have put down: Basics - SQL is easy (11) - Order of query processing https://www.ms-office-forum.net/forum/showthread.php?t=353639

@Minty's suggestion is correct. However, when using it, you must note the following: The assigned column alias only has an external effect and partly in the SELECT part of the query. As a query execution is very different from running through the SQL statement from top to bottom, the column...

The rank generation should then use a different source. ' not SELECT item FROM TabX ' rather SELECT DISTINCT item FROM TabX In a second step, the determined rank would then have to be assigned to all records in the TabX table by linking them via item. This can all be solved using a query...

I'll try it. Two instances of the same table tabX are used. Instance T stands for the display of all fields externally. The subquery is accessed via the filter. Instance X is used in the subquery for the actual calculation. WHERE X.ProductID = T.ProductID This expression acts like a...

I am not entirely sure in which cases exactly, but sometimes the interpreter evaluates the Else branch even if it is not controlled according to the program logic. If V=0, then this results in a division by 0 with a mandatory error. If you keep your expression without taking NULL into account...

Your conclusion is wrong. Of course, if text files always have the same structure, a specification only needs to be created once and then it will remain the same. This is the standard case, which is what we always aim for - with the emphasis on text files with the same structure. However, text...

Using a graphical interface for manual selection interrupts automated programmed processes.

In the old style, the specifications are in two system tables. Once you understand these tables, you can also change the relevant record via query/recordset and thus fully automatically during the import.

Related to the one date field: SELECT StudentID, MIN(DateOfAdmission) AS FirstClassAttended, MAX(DateOfAdmission) AS LastClassAttended FROM tblStudentClass GROUP BY StudentID

Set the delimiter to a character that does not exist in your text, e.g. a pipe. Then the text file content can only be interpreted as a field, provided that there are no line breaks.

To analyze a string, you don't have to import it into a field in an Access table first. With a function like the one linked below, you can read the contents of any file, preferably a text file, into a string variable and then immediately start your analysis and processing. The corresponding...

No. A TextBox wants a single value as its content. A query returns a recordset, which is an object with rows and columns, and even with only one column and one value, a recordset is still an object and not a single value.

The controls in a form have at least the same events in a bound form as in an unbound form, so yes, a double click is usable (in form, not in query).

IIf(DCount("site";"QddallA";"site='site5' and status='in progress' and duedate<date() and isactive=false") +DCount("site";"QddallA";"site='site5' and status='new' and duedate<date() and isactive=false")=0; ""; DCount("site";"QddallA";"site='site5' and status='in progress' and...

The bang operator is not suitable at this point. ' using the recordset's field collection myR.Fields("label" & i) = data(i) ' using the passed array myR.Fields(label(i)) = data(i)

How many records does your table have? Lots of mass makes four work. For 1 product: SELECT TOP 6 * FROM TabX WHERE ProductID = 57 ORDER BY SalesDate DESC The SalesDate field and the ProductID field should be indexed. For all products: SELECT T.* FROM TabX AS T WHERE...

The dilemma is that the CSV file extension is assigned to Excel as the default program for opening it (this is a questionable measure by Microsoft). The second problem is that people do not trust the existing structure in the CSV and want to view the contents first by opening it. Actually, a...

In addition: table definitions do not simply change at will, sometimes PK, sometimes not, values duplicate themselves or disappear. This is nonsense. This can only be understood as corruption in the tables, and a third party is involved. Are we talking about the backend being an Access file and...

Creating a laccdb is a method of making an access file backend-capable. So when a backend is accessed (linking), the laccdeb is created in the same directory or supplemented with the relevant information. So if the backend is accessible and readable, the laccdb (simple text file) should be too...

This is cumbersome. A CSV is a text file, and a text file can be imported more easily, quickly and without problems than an Excel table. Using an import specification gives you a lot of control. If, for example, the text file contains 12 leading lines that do not belong to the actual table, you...