Search results

"I wondered whether Power BI might make it easier to develop ad-hoc queries. However I expect it may not be any simple for an untrained Power BI user to extract and format data, any more than an unskilled Access user. Is that a fair summary?" Not quite sure how to put this. Comparing DAX and...

PowerBI is helpful for interactive graphs and visuals, which is something that Access has never been good at. PowerBI wouldn't replace Access/SQL Server, but would work with it. PowerBI is helpful for drilling into totals and seeing what makes them up etc. The kicker is that PowerBI doesn't use...

I guess it does work. TBH, I haven't seen ANY or SOME since 1999.

I'm sorry, I thought I answered your question. ANY is an Oracle keyword. AFAIK, doesn't exist in Access or SQL Server as a valid keyword. The logical equivalent is to use EXISTS and a correlated subquery. Sorry, TheDocMan's answer is on the mark. Totally missed it somehow.

The short answer to your question is that this is a variation of the "Students and Classes" database. I did one like you're describing like 25 years ago. You will save yourself a LOT of hassle if you find a template or whatever that does most of what you want. (Unless you really understand...

Transformed to equivalent statement without ANY. SELECT e1.empno, e1.sal FROM emp e1 WHERE NOT EXISTS (SELECT e2.sal FROM emp e2 WHERE e2.deptno = 20 AND e1.sal <= e2.sal);

What are you trying to do? Tell us the question you're trying to answer. Are you trying to find all subscriptions without a Closure record? SELECT ... FROM Subscription s LEFT JOIN Closure c ON s.SubscriptionID = c.ClosureID WHERE c.ClosureID IS NULL? or likely easier... SELECT ... FROM...

Sounds like you can save yourself a lot of trouble by just starting with Duane's "At Your Survey" DB. Basically, your call is analogous to an interview (consists of many questions to a single person). Then just grade each question and average them. Or if it's a quiz model you want, I would...