Search results

@Josef P. What does the plan show for the following query? SELECT T, Count(*) AS Cnt FROM TestTab GROUP BY T, N HAVING Count(*) > 1;

Why not test it, then, and prove me wrong? The result will not be the same between the two queries. As @Pat Hartman pointed out, In my example with:WHERE ST.TestDate BETWEEN #1/1/2022# AND #12/31/2022# ...the criterion is applied to the dataset before the grouping takes place, so you will...

Here is a more concrete illustration of the differences between HAVING and WHERE clauses. Table Name: StudentTests StudentID | TestID | TestDate ----------+--------+---------- 10123 | 1012 | 3/1/2022 10123 | 1023 | 9/6/2022 10123 | 1035 |11/17/2022 10123 | 1057 |...

"Explaining a joke is like dissecting a frog. You understand it better but the frog dies in the process." - E.B. White

Assuming that field transaction_id is an auto-increment or sequenced (non-repeating value) field, with the highest number being the most recent, you might try something like: SELECT T.* FROM transactions AS T INNER JOIN ( SELECT MAX(transaction_id) AS transaction_idx FROM transactions...

Yep, the Commodore-64 was the first Commodore machine to use the 6510 microprocessor, which allowed for bank-switching through the byte at address $0001. More detailed information may be found here: https://www.c64-wiki.com/wiki/Bank_Switching

Commodore-64/128 aficionado of old here. To clear up a misconception, the Commodore 64 and 128 do not run on DOS (Disk Operating System); the primary operating system is entirely based in Kernel ROM. Granting that the Commodore 128 allows for a boot sector on its 5-1/4" floppy disks (used not...

Gasman is correct. Because you did not explicitly set variable types, wkm and wkmsql are implicitly set as Variant types, and ADODB.Recordset requires an object type (Dim wkm As Object). This would not necessarily cause problems with late binding in earlier versions of Windows, but it has been...

In any event, using VBA to filter a subreport from the main report does not render consistent results. What would work, consistently, in reference to the example provided by @3gustavo, would be to have the main report RecordSource query refer to Forms![ID Form]![Person ID] as a criterion, and...

Ahh, yes, the OnLoad event works for this as well (subject to the same PrintPreview bug, but there you have it).

True, it does generate the error from PrintPreview, but it shouldn't from Print (at least, it doesn't for me).

You can not perform filter operations on a subreport from the main report's OnOpen event, as it has not yet been instantiated in the Microsoft Access workspace. You need to do this from the main report's OnActivate event, like the following example (substitute MySubformName with the actual...

Unfortunately, here in the USA, there are times when flashing one's car headlights IS used as an aggressive gesture. A prime example is a car on the freeway, moving like a jackrabbit, zipping between the other cars, and the driver of the car will tailgate a car directly in front of him/her and...

Hello, @arnelgp, Thank you for the reference to my code (wow, that was a long time ago!) I have since simplified it to the following: Public Function Ceiling(ByVal number As Double, ByVal significance As Double) As Double Ceiling = Int(number / -significance) * -significance End Function...

Try changing: "SELECT p1, SELECT p2;" ...to: "SELECT p1, p2;"

You will need to change: req.getResponseHeader "Authorization", "Bearer " & mToken ...to: req.SetRequestHeader "Authorization", "Bearer " & mToken

...and maybe get the ball bearings sharpened, yes?

I wrote an Engineering Change Management application that would allow for integration of various CAD application bill-of-material data with the company's MRP system. For those users who love to double-click everything, including buttons, I incorporated an Easter egg that would, after so many...

A new supermarket opened in Tampa, Florida... It has an automatic water mister to keep the produce fresh. Just before it goes on, you hear the sound of distant thunder and the smell of fresh rain. When you pass the milk cases, you hear cows mooing and you experience the scent of fresh mowed...

There is one code error that I can see right away. Try changing: oHTTP.setRequestHeader "Authorization", "Basic" & cadena ...to: oHTTP.setRequestHeader "Authorization", "Basic " & cadena (note the space after the word Basic)