Recent content by Pat Hartman

But if you use the QBE, you have no need to even look at the generated SQL. So, if you are looking at the SQL, is it because you are then taking the generated SQL and trying to embed it as text? I'm pretty sure that all the excess parentheses are there to help with converting the string to the...

If there were a successful society that operated on socialism today, surely you would have mentioned it. Don't try to cite the Scandinavian countries. They are not Socialist. You could mention North Korea or Cuba but I doubt either has an illegal immigrant problem;) Socialism was part of...

@arnelgp has shown you the correct way to solve this problem. It is always better to use left joins instead of the dLookup. That allows the data engine to create the most efficient retrieval of the data. You use Left joins to solve the problem of the record you are trying to retrieve not...

Remember the IIf() is IIf(condition, true path, false path) And either or both the true path or the else path can be nested. This is why you need to indent properly so you'll see what path you are on. IIf(condition, truepath IIf(condition2, true path, false path), falsepath IIf(condition3...

You always have to question statements made by people with an axe to grind. If Harvard gets what they deserve for their anti-semitism and lies, they will loose their tax exempt status. They may end up keeping their grants for this year due to woke judges but they will get no more.

I gave you several hints earlier and asked you to give it a try. We are happy to help but we shouldn't just do it for you. For your own good, you need to make a start. I suggest you start by converting the IIf() to an If-Then-Else format on paper. Be conscious of properly indenting the code...

I hate to add to your discomfort but the essential problem is the cross-posting. The experts here are all volunteers. No one is getting paid to help you. When you can't be bothered to wait for an answer on a single forum and so post in another, you start a second group of experts looking at...

The query should be pulling the data in a format that facilitates the export rather than one that is "easy to read".

Did you send that link to Biden? He was PERSECUTING Trump by having corupt AG's bring bogus lawsuits to keep Trump from running/winning. Apparently some of those people are also guilty of committing other crimes, should those charges not be pursued for actual criminal activity? "Already, this...

Let's go back to why aren't the Access tables properly normalized to begin with? Then you don't have to transpose.

Given her official position, should she be prosecuted, she should get no "take back". She deserves the highest penalty the law provides because she violated the faith of the American people who voted for her by her lies and gaming of the system.

I get it. My point was subtle and I had made it earlier so I didn't repeat it. Just because you say you are being persecuted and your life is in jeopardy, doesn't make it easy to prove on a case by case basis. So, unless you live in a warzone or a country ruled by warlords, asylum isn't...

When I first started using a relational database (DB2) back in the 80's, the only option was embedded SQL. There was a preprocessing step for the compiler that extracted the SQL strings (I don't remember how they were identified) and evaluated them separately. Then if that succeeded, the...

What a truly stupid comment. Usually they comment about what the women are wearing. Apparently Melania didn't offend anyone. I think he likes blue. He wears blue suits a lot. Is that not OK because he's Trump? Or is he supposed to dress in lockstep with the men around him? Is black the...

@moke123 You deflected again and refused to state your opinion on your "deportation of children" comment. And you don't seem to be interested in the larger question of dependents of incarcerated/deported parents which creates a lot of unintended victims. This would be a conversation that...